user989988
user989988

Reputation: 3746

SQL Query using script activity in ADF

I have the script activity in ADF pipeline:

enter image description here

On running this, I see the following error. What does this indicate and how do fix this?

enter image description here

Upvotes: 1

Views: 4807

Answers (1)

AnnuKumari
AnnuKumari

Reputation: 563

You are trying to make tableName dynamic. It won't work like that. Better create a variable and use Set variable activity to set the tableName. Then use the same in your script Activity.

select * from @{variables('tableName')} where id=@id

Set variable activity settings: enter image description here

Here is the script activity settings: enter image description here

Output : enter image description here

Upvotes: 2

Related Questions