SSIS - Reading multiple source files using Foreach Loop Container 

Thank you. The videos are under rated. It should get more popularity.

Thank you so much. Assuming that the target is a database table, how to change this logic to read the files in parallel and load into the target in parallel instead of sequentially? The actual requirement is a SQL task prior to the Foreach Loop is feeding a list of databases against which same SQL has to be run in parallel (as the SQL runs for a long time) on all the databases that the Foreach Loop receives and the data extracted from each database should be loaded to the same target table in the target database.

Thank you so much. Clear and neat explanation. It helps me a lot!!

Thanks Madam. Good Explanation. and it is the real time senario what I am looking. Finaly got it.

Thank you for this video

If we have excel files and new columns are introduced in the data how do we update the package?

Thank you so much :) really help me :)