How to load Multiple CSV Files to SQL Tables dynamically And Save File Name and Rows Copied in Audit Table Azure Data Factory Tutorial 2021 - ADF Tutorial 2021, in this video we are going to learn How to load Multiple CSV Files to SQL Tables dynamically And Save File Name and Rows Copied in Audit Table - Azure Data Factory Tutorial 2021 - ADF Tutorial 2021 Step by Step ADF Tutorial - Azure Data Factory Tutorial 2021.
Azure Data Factory Tutorial for beginners
Azure Data Factory Tutorial 2021
Step by step Azure Data Factory Tutorial
Real-time Azure Data Factory Tutorial
Scenario base training on Azure Data Factory
Best ADF Tutorial on youtube
TSQL Script:
create table dbo.auditlog(
id int identity(1,1),
Pipelinename varchar(200),
FileName varchar(100),
RowCnt int)
create procedure dbo.insertaudit
@Pipelinename varchar(200),
@FileName varchar(100),
@RowCnt int
AS
BEGIN
insert into dbo.auditlog (Pipelinename,FileName,RowCnt)
values (@Pipelinename,@FileName,@RowCnt)
END
Select * From dbo.auditlog
#AzureDataFactory #ADFTutorial2021
