have two tables tbl1 and tbl2. I want to create a package which will read the data from tbl1 and tbl2 and transfer the data to Azure data lake as two files tbl1.txt and tbl2.txt
.
What I have done is created Execute SQL task
with query select name from sys.tables
,which will return table names and loop through that result and store into store variable. But Oledb Source doesn't accept query like
select * from @[user::tablName] (a variable which has a table name)