Hello Team,
I am using the copy activity pipeline and using the QUERY :
Select *
from @{pipeline().parameters.Schema}.
[@{pipeline().parameters.Companies[0]}$@{pipeline().parameters.TablesWithCompany[0]}]
In This @{pipeline().parameters.TablesWithCompany[0]} there are 1139 tables need to pass the value.
example from the screenshot
select from dbo.Group$Acc_ Sched_ Cell Value
select from dbo.Group$Acc_ Sched_ Chart Setup Line
.select from dbo.Group$Item Discount Group
.
.
.
select from dbo.Group$Item Cross Refer
If you refer the screenshot i am getting the error :
Please advise how it can be handle.
