How to create dynamic number of output files with SSIS?
Posted
by JSacksteder
on Stack Overflow
See other posts from Stack Overflow
or by JSacksteder
Published on 2010-03-09T19:10:51Z
Indexed on
2010/03/13
17:05 UTC
Read the original article
Hit count: 161
Filed under:
ssis
|connection-manager
I will be creating flatfiles and based on the data in the batch, it might be necessary to split the data into an undetermined number of files.
I can make the connection string dynamic with an expression, but that is only evaluated when the package starts. I'd like to change that expression to include a '-a' or '-b' in the filename.
Alternately, if I have to create new connection manager objects at run time on demand, how do I go about that?
© Stack Overflow or respective owner
