Just wondering if its possible for SSIS 2005 to save a copy of Ms EXCEL to 97-2003 Workbook? Because I want to take a copy of an EXCEL which is currently under 2007 version, and i want to make a copy of it and save it as 97-2003 version... so i can then import the dataset using SSIS. thanks

It's possible using the highly unreliable Excel COM API. However, what you've described doesn't seem to make a lot of sense... you want to open a 2007+ workbook (XLSX) in SSIS, save it as a 2003 (XLS), so that you can open it with SSIS? Why not just open the 2007 workbook in SSIS to import the data? Talk to me now on

I'm guessing that he doesn't have the correct drivers loaded and is trying to figure a way around it. The drivers you need to use the 2007 workbook in SSIS are here.: Load the 32 bit version. http://www.microsoft.com/en-us/download/details.aspx?id=13255Chuck Pedretti | Magenic North Region | magenic.com

thanks, i'll give it a try