How to Load Multiple Excel Files with Same Sheet Name to Azure SQL Table by using Mapping Data Flow

How to Use Filter Transformation in Mapping Data Flow in Azure Data Factory - ADF Tutorial 2022, in this video we are going to learn How to Use Filter Transformation in Mapping Data Flow in Azure Data Factory - ADF Tutorial 2022, Azure Data Factory Step by Step - ADF Tutorial 2022 - ADF Tutorial 2022 Step by Step ADF Tutorial - Azure Data Factory Tutorial 2022
Script:
How to Load Multiple Excel Files with Same Sheet Name to Azure SQL Table by using Mapping Data Flow in Azure Data Factory
TotalSale create table definition
CREATE TABLE [dbo].[TotalSale](
[id] [int] 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) NULL
)

TotalSale_Asia data
id,SalePersonFName,SalePersonLName,ProductName,ItemsSold,SoldPrice,SoldDate,City,State,Country,Region
5,Najaf,Ali,Computer,1,300,2015-06-20,Karachi,Sindh,Pakistan,Asia
6,Sukhjeet,Singh,TV,2,900,2015-06-21,ChandiGar,Punjab,India,Asia
7,Chirag,Patel,Cell Phone,5,1500,2015-06-23,AhmadAbad,Gujrat,India,Asia
8,Aleena,Aman,Laptop,2,800,2015-05-25,Lahore,Punjab,Pakistan,Asia

TotalSale_Europe data
id,SalePersonFName,SalePersonLName,ProductName,ItemsSold,SoldPrice,SoldDate,City,State,Country,Region
9,Petra,Henry,TV,10,5000,2015-04-08,Paris,Île-de-France,France,Europe
10,Rita,Roger,Laptop,7,2100,2015-04-11,Paris,Île-de-France,France,Europe
11,Tamara,Tony,Cell Phone,2,1200,2015-03-03,Frankfurt,Hesse,Germany,Europe

TotalSale_NorthAmerica data
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

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

[Sitaram-ekcc]

How do you load multiple Excel workbooks with multiple sheets (but sheet1 format is the same in all Excel workbooks and the same for sheet2 and sheet3..)?

[gaurangkulkarni]

Hi, we can use this method to transfer multiple large files too right? As in like 20 files of 10-15 GB?