How to Load Multiple CSV Files with Different Columns to Azure SQL Table by Using Data Flow in ADF

How to Load Multiple CSV Files with Different Columns to Azure SQL Table by Using Data Flow in ADF - 2022, in this video we are going to learn How to Load Multiple CSV Files with Different Columns to Azure SQL Table by Using Data Flow in ADF - 2022, Azure Data Factory Step by Step - ADF Tutorial 2022 - ADF Tutorial 2022 Step by Step ADF Tutorial - Azure Data Factory Tutorial 2022 Script: TotalSale_ExactColumns.csv id,SalePersonFName,SalePersonLName,ProductName,ItemsSold,SoldPrice,SoldDate,City,State,Country,Region 1,Aamir,Shahzad,TV,1,700,2015-07-15,Charlotte,NC,USA,North America 2,M,Raza,Cell Phone,2,800,2015-07-15,Charlotte,NC,USA,North America 3,Christy,Ladson,TV,3,1600,2015-04-02,High Point,NC,USA,North America 4,John,Rivers,Laptop,5,2400,2014-03-09,Jersey City,NJ,USA,North America TotalSale_ExtraColumn.csv id,SalePersonFName,SalePersonLName,ProductName,ItemsSold,SoldPrice,SoldDate,City,State,Country,Region,NewColumn 5,Najaf,Ali,Computer,1,300,2015-06-20,Karachi,Sindh,Pakistan,Asia,This is an Extra Column for Test 6,Sukhjeet,Singh,TV,2,900,2015-06-21,ChandiGar,Punjab,India,Asia,This is an Extra Column for Test 7,Chirag,Patel,Cell Phone,5,1500,2015-06-23,AhmadAbad,Gujrat,India,Asia,This is an Extra Column for Test 8,Aleena,Aman,Laptop,2,800,2015-05-25,Lahore,Punjab,Pakistan,Asia,This is an Extra Column for Test TotalSale_LessColumns.csv ID,SalePersonLName,SalePersonFName 1,Aamir,Shahzad 2,M,Raza 3,Christy,Ladson 4,John,Rivers ) TotalSale Table definition CREATE TABLE [dbo].[TotalSale] ( [id] [int] not null ,[SalePersonFName] [varchar](100) NULL ,[SalePersonLName] [varchar](100) NULL ,[ProductName] [varchar](100) NULL ,[ItemsSold] [int] NULL ,[SoldPrice] [float] NULL ,[SoldDate] [date] NULL ,[City] [varchar](100) NULL ,[State] [varchar](100) NULL ,[Country] [varchar](100) NULL ,[Region] [varchar](100) NULL, FileName varchar(100) ) Select * from [dbo].[TotalSale] truncate table [dbo].[TotalSale] Azure Data Factory Tutorial for beginners Azure Data Factory Tutorial 2022 Step by step Azure Data Factory Tutorial Real-time Azure Data Factory Tutorial Scenario-based training on Azure Data Factory Best ADF Tutorial on youtube #AzureDataFactory #ADFTutorial2022