I currently have a DTS package that outputs to 7 different text files based
upon criteria in the SQL query. The text files are dumped as comma delimited
files and goto different folders on the Network. Is there a way (Global
Variables) that I can run this package without having to edit each one of
the text file connections and change the names each run. Should I just

The file output name format is:

\\folder\subfolder\plant#weeknbryear.csv


I would like to automate so I don't have to touch the package weekly.


looking for any examples or suggestions.


thanks.

Are you looking for something similar to this:-

How can I change the filename for a text file connection?
(http://www.sqldts.com/default.aspx?200)

"HoosBruin" <Hoosbruin (AT) Kconline (DOT) com> wrote