Using Excel 2007 files as a Source in SSIS 2005

Thanks to “jaegd” for his post here:¬†forums.microsoft.com/… on how to accomplish this. Below please find some more details along w/ a example which can be downloaded here (ssis-2005-excel-2007-source-example). Steps Create new OLEDB Connection by right clicking on the Connection Manager tray Chose any valid type or value for the connection and click okay Rename the…

Continue reading →