Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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
Author
Message
Posted Monday, September 1, 2014 6:45 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, December 15, 2014 9:05 AM
Points: 11, Visits: 23
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