Load Excel File with Multiple Sheets Dynamically by using Lookup Activity in Azure Data Factory 2021

How to Load Excel File with Multiple Sheets Dynamically by using Lookup Activity in Azure Data Factory Tutorial 2021, in this video we are going to learn How to Load Excel File with Multiple Sheets Dynamically by using Lookup Activity in Azure Data Factory Tutorial 2021, Azure Data Factory Step by Step - ADF 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

#AzureDataFactory #ADFTutorial2021

[zakariiabadis]

When u wake up and u find techbro’s Notifications. Your day is really made
I love u man !

[jahanvitiwari]

for some reason my table is not getting loaded with any rows except the top header row i also checked and have the top row only option deselected.. what could be the problem?/

[Healthposts]

another great video. many thanks Amir Bhai

[apurvasharma]

My pipeline is failing because of 'Worksheet doesnt found'. I want pipeline to ignore file which doesnt have sheetname and pick only which have sheetname in it.
Is it possible to do in ADF?

[williamtenhoven]

What would be the 'truncate script' in the 'Pre-copy script' section ? Can't get this right. I have @concat('delete from @dataset().dsTableName') but this does not work.

[sharathchandra]

Thank you for video… could I know how do got tables from excel to sql server.

[lukylega]

Really good. Thank you!!
One question: what happens if I have 5 Sheetnames on my Azure SQL table and the excel file that is being read only has 3 of those 5. Would it still work?

[Nappa]

Thank you for the video...but please switch off that mouse click sound !!! :)

[garysankar]

Getting this error and tried several fixes but none work. Any suggestions?
Error
Notifications
Operation on target ForEach1 failed: Activity failed because an inner activity failed; Inner activity name: Copy data1, Error: ErrorCode=ExcelInvalidSheet, 'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException, Message=The worksheet cannot be found by or index:'-1' in excel file 'Weekly Updates.xlsx'., Source=Microsoft.DataTransfer.ClientLibrary, '


Thanks

[sahilgupta]

Can we do this task without putting an entry in the sheet table?