Hi,
I would like to create a dynamic package which exports results of
different stored procedures
with select statement and different number of columns to a .csv file.
I've already got a script which changes SourceSQLStatement to 'exec '
+ sp_name and
and Connection DataSource property to the name of the .csv file. Now
the question is how can I have 'variable' transformations for variable
number and types of columns?
Is it possible in SQL Server 2005 SSIS?

Thanks

polinaskulski (AT) aol (DOT) com wrote:
You cannot. The metadata, the column definitions and structure of the
pipeline which moves the data is fixed at design-time. You would have to
write some logic to parse the procedure output format and build the
package on the fly. The only other alternative would be to put all
results into a single column table, already in CSV format.


--
Darren
http://www.sqldts.com
http://www.sqlis.com