#73. Azure Data Factory - Dynamically Load from XL sheets to different SQL table

This Video explains the steps required to load data from multiple XL files to multiple azure sql table using parameterized datasets.

[PurushothamM-dh]

Mam, I have 2 (emp.xlsx and payroll.xlsx) file in blob and want to copy that into 2 table(emp and payroll) in Azure SQL database . How possible?

[NasimaKhatun-jbqo]

Ma'am, can we load multiple sheet as files in adls, can you show that. I am getting error in that

[sudhakark]

Great explanation, can you please upload multiple files and multiple sheets load aswell

[reenageorge]

Hi, Is it possible to get the sheet name dynamically without specifying in text file

[sdhilip]

Amazing explanation madam. I have a scenario. Every day excel file gets uploaded in Data Lake with the filename and date. Each excel file has 5 sheets. I need to read these excel sheets in ADF and export them into SQL Database. This video helped to read multiple sheets. However, not sure how to reach the every day file in ADF. Mam, can you explain how to take the latest file in Data lake through ADF?

[sarvanikeella]

I am a newbie to ADF, please dont mind if my question is lame. In this scenario, How to the column mapping happen? Are the both sheets have same column structure? If different, How to deal with them?

[priyankapatel]

Hello mem
How we can copy multiple file from blob to SQL tables?

[AshwaniAshish]

Hi ma'am.. i have a scenario wherein I have multiple files getting created using copy activity within a for-each. The vendor requires us to send a single file. Is there any way around in adf using which I can merge the files into a single file? And your videos are indeed very helpful.. much thanks..

[akhilkumarsr]

How the field mapping is performed in copy activity

[insane]

explain lookup activity mam. i get error every time