01 SSIS Load From Excel Files with For Each Loop

[@Gordon342007]

Thanks Ted. I had tried other explanations to no success but this worked perfectly.

[@MattDonnelly-xg6bz]

Thanks Ted for the great video. Very useful and easy to follow.

[@arnabgupta4391]

Thanks, Ted for the video. It has been of great help, I literally was struggling for a long time as I assumed Delay validation = True was to be set in the property for the FOREACH Loop Container.

[@MrShadyabs]

Yes it's better be

[@sanjayakumarpadhy9999]

Thanks Ted. It is an excellent video and the explanation given by you is outstanding. It helps me lot.

[@MkMc80]

This video has been a huge help to me. Thank you!

[@techbrojoe]

Thank you for this. I was trying to follow Microsoft's documentation and their instructions didn't really make any sense since they don't explain the variable you're putting on the ForEach Loop is actually the ConnectionString value via an expression.

[@christinaash1793]

Hello. This video is so helpful. I would like the data conversion table you show. I apologize, but cannot find video note...I am dumb to navigate TH-cam and find it :( Could you please send or post some other way? Thank you for this video either way. You are so clear in your direction.

[@ridethecatbus]

Could you re-link the data type chart from Excel to SQL you mentioned in the video? The link doesn't work and i would be so grateful to have that cheat sheet.

[@rahul-zh6ir]

Thanks partner this helped me alot

[@teunkruijer]

So Simple but so usefull. Thanks a lot!

[@MrPapeBoubacar]

Great Ted ! The black screen does not help though.

[@XxPIOJIxX]

Thanks!! Very helpful

[@yuvarajarul5074]

thanks ted
worked 🙂

[@mario17-t34]

Tx, do you know how to refer to Worksheet name dinamically (single, or first one) Tx

[@Mikhail-h1m]

thanks... it was really helpfully

[@ahamednj5969]

thanks for the help.

[@mario17-t34]

it's Nov 2018 I'm on all most recent versions and I don't have option under Collection in , can anybody knows why,

[@arnabgupta4391]

You definitely have the property of Directory, must have been due to weird design layout of the Editor Window you might have missed it. Once you are in collection, click on the furthest right on the Expressions. Once inside the Property Expressions Editor, you can set your Directory to your variable.

[@Eleochess]

Excelent!! Thank you!!!