Set the source directory for "Text File Source"

[umeman]

Hi,

I am writing 15-20 dts packages that load data from tab
delimited text files into MS SQL tables.

If for some reason the source directory changes I would need to change all of these DTS packages.

Is there a way that I can set the source directory
of the "Text File Source" connection so that is the source
directory changes I can just change the parameter in some file similar to the way I can use a UDL file.

e.g. Files to be loaded
d:\data\customers.txt
d:\data\vendors.txt

This changes to:

e:\data\reporting\customers.txt
e:\data\reporting\vendors.txt

Thank you
Ume

 

[stiej]

you could create a text file, as you've put in your example above, and read in the two lines into seperate global variables then assign these global variables to the source connection bit of your connection using the dynamic properties task. Should work.