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.