Hi Folks I need to load multiple files from a folder into a package. Can someone explain the pros and cons of using the "Multiple Flat file connection manager" vs using a" For each loop" type approach (e.g http://bi-polar23.blogspot.com/2007/08/loading-multiple-excel-files-with-ssis.html). Many thanks Steve

Hi Steve_Fox, See a post relating to "Multiple Flat file connection manager" - http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/b27c83fa-6529-45d4-80ac-5fa7ec44cf53Sergei

Hi Folks I need to load multiple files from a folder into a package. Can someone explain the pros and cons of using the "Multiple Flat file connection manager" vs using a" For each loop" type approach (e.g http://bi-polar23.blogspot.com/2007/08/loading-multiple-excel-files-with-ssis.html). Many thanks Steve Any use? Processing data from multiple files all at once @Jamiethttp://sqlblog.com/blogs/jamie_thomson/ | @jamiet | About me

check http://plexussql.blogspot.com/2010/04/looping-through-excel-files-and-sheets.htmlSincerely SH -- MVP, MCITP 2008, MCTS 2008 & 2005 -- Please kindly mark the post(s) that answered your question and/or vote for the post(s).

Thanks for the insight folks. Exactly what I was after. Cheers Steve