Good book with many useful examples and insights but believe it or not, I found a few things that weren't covered in it!

I have a DTS package that has a single source connection to a SQL 2000 Server and 20 destination connections producing flat files. The flat files generated need to be placed into one of four subfolders depending on who the package is being run for.

Because of this, I need to be able to modify the output filename on each of the 20 output files dynamically. Dynamic properties won't work (I don't think) unless I can create one on the fly and then establish constraints around it and then execute it.

I can make this whole thing function like I want if I could:
  A. Directly modify the Connection object's properties through the connection's Properties property.
  B. Or if I could actually create a connection object dynamically. (Strange that the book implies that a complete DTS package ought to be able to be created via a Visual Basic progam, but the only examples shown are for dynamically creating Tasks and Steps.)

Does anyone know to modify the DTSFlatFile destination filename?

It is not the critic who counts...  [T.Roosevelt]