Closed saikoneru1997 closed 1 week ago
To get schema and tables name we can use below query
select TABLE_SCHEMA, TABLE_NAME from INFORMATION_SCHEMA.TABLES where table_type='BASE TABLE' and TABLE_SCHEMA='dbo'
we will get output like
to loop each table we need to use for each activity
within the copy activity create parameters and pass values as below
in sink we can use
@concat(item().TABLE_SCHEMA,item().TABLE_NAME,'.csv')
To get schema and tables name we can use below query
select TABLE_SCHEMA, TABLE_NAME from INFORMATION_SCHEMA.TABLES where table_type='BASE TABLE' and TABLE_SCHEMA='dbo'
we will get output like
to loop each table we need to use for each activity
within the copy activity create parameters and pass values as below
in sink we can use
@concat(item().TABLE_SCHEMA,item().TABLE_NAME,'.csv')