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?