sql server dts: Dynamic transformations in SSIS -- sql server dts

Dynamic transformations in SSIS

polinaskulski NO[at]SPAM aol.com
1/27/2006 2:27:18 AM

sql server dts: 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

Re: Dynamic transformations in SSIS

Darren Green
1/27/2006 7:10:28 PM

[quoted text, click to view]

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