Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
Hi @Rohit Kulkarni ,
Would you please try "sqlReaderQuery" : "Select *\nfrom dbo.\n[Displays_Direct$@item().TableName]"
Thanks!
Copy activity
Rohit Kulkarni
441
Reputation points
Hello Team,
I am using For each activity under that i am using the copy activity.
Input
{ "source":
{ "type": "SqlServerSource",
"additionalColumns":
[
{
"name": "Companies",
"value": "Displays_Direct" },
{ "name": "TablesWithCompany",
"value": [ { "TableName": "Acc_ Sched" },
{ "TableName": "Sched " },
{ "TableName": "Sched_ KPI " },
I need to pass the "TableName" value in the below mentioned query.I am not not able to understand what has to be passed.
Now i am passing the item. It is not working.
"sqlReaderQuery" : "Select *\nfrom dbo.\n[Displays_Direct$@item().TablesWithCompany]",
It has to be like this
"Select *\nfrom dbo.\n[Displays_Direct$Acc_ Sched]" ( it will copy the 1 foldername in blob storage)
"Select *\nfrom dbo.\n[Displays_Direct$Sched]" ( it will copy the 2 foldername in blob storage)
"Select *\nfrom dbo.\n[Displays_Direct$Sched_ KPI]" ( it will copy the 3 foldername in blob storage)
Please advise.
Thanks RK
Azure Data Factory
{count} votes
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(172.8, 70%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMM%3C/text%3E%3C/svg%3E)
MartinJaffer-MSFT 26,161 Reputation points2021-04-16T16:41:40.68+00:00 Are you still facing the issue?
Sign in to comment
1 answer
Sort by: Most helpful
-
Nasreen Akter 10,891 Reputation points Volunteer Moderator2021-03-25T19:41:20.857+00:00 -
Rohit Kulkarni 441 Reputation points
2021-03-25T19:44:40.137+00:00 Orginal query is
select * from dbo.[Parameter1$Parameter2]
Parameter 1;Displays_Direct
Parameter2:????Select *f rom dbo.[Displays_Direct$@item().TableName]
"Select * from dbo. [Displays_Direct$Acc_ Sched_ Cell Value]" ( it will copy the 1 foldername in blob storage)
"Select * from dbo. [Displays_Direct$Acc_ Sched_ Chart Setup Line]" ( it will copy the 2 foldername in blob storage)
"Select * from dbo. [Displays_Direct$Acc_ Sched_ KPI Buffer]" ( it will copy the 3 foldername in blob storage)
Thanks
RK -
Nasreen Akter 10,891 Reputation points Volunteer Moderator
2021-03-25T20:19:31.74+00:00 Hi @Rohit Kulkarni ,
I am a little confused here, the params you have are they pipeline parameters? If yes, then you do not need to provide any additional columns in the copyActivity-->Source side. The following query should work:
select * from dbo.[@{pipeline().parameters.Companies}$@{item().TableName}]
-
Rohit Kulkarni 441 Reputation points
2021-03-25T20:26:55.73+00:00 It is not working. Please suggest some idea.
-
MartinJaffer-MSFT 26,161 Reputation points
2021-03-31T19:05:30.58+00:00 What is it doing if it is not working?
-
MartinJaffer-MSFT 26,161 Reputation points
2021-05-27T22:42:07.783+00:00 If you found your own solution, please share here with the community.
Sign in to comment -