Dynamically setting path to source csvfiles

[Padre764]

Hello,

I have a DTS package with over a dozen csv source files. All of source files will be in the same directory but, the directory will not be in the same location on every machine that I need to run the package on. I know that I can use the Dynamic Properties task to set the path for each file. My question is: Is there a way to use a variable in the path to each file so that I only have to set the path variable once (instead of having to do it for each file)?

 

[nigelrivett]

You can use an activex script to set it in each task.
Do you have to use dts though - bcp is a lot simpler

see

http://www.nigelrivett.net/s_ProcessAllFilesInDir.html

http://www.nigelrivett.net/ImportTextFiles.html

======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.