I'm trying to save an excel spreadhseet from SQL Server Integration Services 2005.
Unfortunatly I only seem to be able to save in 2003 format but I want to be able to save in 2007 format. Is there wa way to do this?
+1
A:
That should be possible using the OLEDB connection manager. (Not the Excel connection.)
Take a look at this example. It is for importing, but it should be suitable for exporting as well. Remember to use the XML format as described here. And in more detail here.
Magnus Johansson
2009-05-26 12:49:52
I’ve managed to write to an excel 2007 workbook as described in the section “Connecting to a Workbook in Excel 2007 Format “ at this url http://msdn.microsoft.com/en-us/library/cc280527.aspxThe trick is to use an OLE DB connection for the workbook rather than an excel connection (of course!). According to this link http://dougbert.com/blogs/dougbert/archive/2008/06/16/excel-in-integration-services-part-1-of-3-connections-and-components.aspx will need to wait for 2008 before they let you choose the 2007 workbook as an option
AJM
2009-05-26 13:03:25