SSIS - Export multiples resultsets to Excel files without a template file

• M. Gamito

  SSC Enthusiast

  Points: 199

  More actions

  September 1, 2014 at 6:45 am

  #311163

  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 !