Have Geek Brain

SSIS Format - Save to Office 2007

I am trying to save excel spreadsseet from SQL Server Integration Services 2005.

Unfortunately, it seems to me that I can only save the 2003 format, but I want to save it in the 2007 format. Is there a way to do this?

0


a source to share


1 answer


This should be possible with the OLEDB connection manager. (Not an Excel connection.)



Check out this example . It is meant to be imported, but it must also be suitable for export. Remember to use the XML format as described here . And in more detail here .

+1


a source






More articles:


All Articles