How to Load Data from Multiple XL Sheets to Azure SQL Tables in Azure Data Factory - ADF Tutorial

[@sravankumar1767]

Nice explanation 👌

[@sriramch3128]

Thanks for the video

[@cindyw6368]

Hi Amir. While doing this if I get any datatype issues, where to use the derived column transformation.

[@TechBrothersIT]

We can skip those rows and redirect them to log file for further investigation. I have videos on those topics too, please check in playlist.

[@cindyw6368]

Hi Amir. I don’t want to skip those columns. I want to include those columns but I need to change the data type of those columns. How to do that?

[@Thechaitanya431]

All your videos are most helpful.Amir Can you please make a video on how to consume API data into Ssis using c# in 2010

[@TechBrothersIT]

Thank you, I will try.

[@arkabhattacharya4163]

What if I don't have the sheet name but need to get it at run time.

[@TechBrothersIT]

I tried to do that too but looks like this is not supported or you use Azure function. If you don't know the sheet name, you can use index. I will further look into this.