Hello,
I have a table in sql server on prem called dbo.TableNames
There are three rows:
ID TableName
1 table1
2 table2
3 table3
I would like to loop through the dbo.TableNames table and copy into sink...
At present, I have a copy activity which takes a parameter, pEntityName and then depending on which table name I physically type in there, it copies from source(on prem sql) to sink. This bit is fine.
The question I have is how to read each table inside dbo.TableNames and pass each tableName into the copy activity pEntityName parameter?
Thank you
