using AZURE DATA FACTORY,
create pipeline using SQL Query

—>IN LOOKUP QUERY :(select name, format(create_date, ‘yyyyMMdd’) creationdate from sys.tables where cast(create_date as date)= ‘2024-04-23’)

where

—-> for each
parameter1: name
parameter2: creationdate

copy: dbo.name
sink:
folder creationdate
filename: name.csv

copy tables LIKE THIS:

NAME CREATION DATE
sysdiagrams 20240423
Customer 20240423
ProductModel 20240423
ProductDescription 20240423
Product 20240423
ProductModelProductDescription 20240423
ProductCategory 20240423
BuildVersion 20240423
ErrorLog 20240423
Address 20240423
CustomerAddress 20240423
SalesOrderDetail 20240423
SalesOrderHeader 20240423

using AZURE DATA FACTORY,
create pipeline using SQL Query

—>IN LOOKUP QUERY :(select name, format(create_date, ‘yyyyMMdd’) creationdate from sys.tables where cast(create_date as date)= ‘2024-04-23’)

where

—-> for each
parameter1: name
parameter2: creation date

copy: dbo.name
sink:
folder creation date
filename: name.csv

copy tables LIKE THIS:

NAME CREATION DATE
sysdiagrams 20240423
Customer 20240423
Product Model 20240423
Product Description 20240423
Product 20240423
Product Model Product Description 20240423
Product Category 20240423
Build Version 20240423
Error Log 20240423
Address 20240423
Customer Address 20240423
Sales Order Detail 20240423
Sales Order Header 20240423