Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

SSIS - Export multiples resultsets to Excel files without a template file Expand / Collapse
Posted Monday, September 1, 2014 6:45 AM


Group: General Forum Members
Last Login: Friday, January 29, 2016 9:32 AM
Points: 13, Visits: 36
Hi all !

I am trying to use SSIS to export multiples resultsets into different Excel files.

The problem is that the number and the name of the columns change from one resultset to another so I can't use a template file like I do at Excel Connection Manager.

I need to dynamically generate the Excel file based on the resultset layout.

This is urgent for me so any help is welcome.

Thanks !
Post #1609337
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse