| Darren Green 2006-01-27, 1:23 pm |
| polinaskulski@aol.com wrote:
> 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
>
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
|