Please bear with me, I am very new to dts.

I have a small package that I execute with the dtsrun command from a stored
procedure. It simply copies the values from a sql table to a text file. So
far so good. I now want to be able to pass the destination path as a variable
to the package. I have spent a lot of time searching a lot of websites
reading a lot of code and am now completely loopy.

I can set up a global variable in the package via the dynamic properties
task and I can set a value here which alters the output destination. I
haven'y been able to do this from outside the package though (which defeats
the purpose of having a global variable. If I have to enter the package to
change the destination I may as well do it on the connection). I've tried the
dtsrun /A switch to no avail.

I have successfully used an activex script in the package which alters the
output destination. I haven'y been able to do this from outside the package
though.

What am I missing?

Marc

Dynamic Properties Task. Store the location into an ini file, use the
dynamic properties to change the value of the connection object (your
text file) to whatever is stored in the ini file. I have used this
dozens of time without failure. I can send you a screen shot if that
helps..

Tim Heap
Software & Database Manager
POSTAR Ltd
www.postar.co.uk
tim (AT) postar (DOT) co.uk

*** Sent via Developersdex http://www.developersdex.com ***