SSIS Multiple Excel Files Import | using foreach object

Tutorial showing how to import multiple excel files into a SQL table using the foreach container and variables. The Microsoft Access Objects may be required to perform this tutorial.

[colaguibel]

Finally a very well explained process on loops; I used it for Ms Access files and worked too

[kristy.rlopez]

Thanks a lot for sharing this tutorial!! I keep having issues because the Excel Source task couldn't read files with multiple names but now the issue has been fixed!! Again thanks a lot!!!

[demirmahmut]

Thank you so much, after spending lots of hours, I found your video and solved multiple excel data transfer problem :)

[gleomarperez]

Thank you, gracias!!! me estaba volviendo loca!

[nicolasdiaz]

Great video. Very clear, step by step and easy to understand. It helps me a lot. Thanks!

[abefroman]

When I run this with the start button, it just hangs / does nothing. When I execute just the container, it displays the first file, and then the DFT does nothing (if I use a data viewer, it does not read the excel file). Any guesses what needs to change?

[PS-vcef]

Great video! Thank you! I am surprised you didn't have to do datatype conversion from excel Unicode datatype to non-Unicode datatype!

[ravekid]

I got this working in VS, but when deploy it I get an error about the ACE OLEDB 12 driver not being installed. Does anyone know what would cause this to throw an error in SQLServer but not VS?

[javierrodriguez]

What would you do if the worksheet structure is the same but the sheetname is different in each excel file? it always matches the file name

[tungnguyenuc]

How can I make my SISS project automatically run, sir ?