I have a DTS package that imports a text file. The test file it import
depends on a global variable that an activex script looks up while its
running (it changes the source of the Text File (Source) connection).

It all works fine.

My question is this - if more than 1 client accesses the DTS package at the
same/nearly the same time it is possible for them to interfere with one
another -
e.g. Client 1 starts off and passes user1.csv to the package and the activex
fires and changes the path to user1.csv.

Then client2 starts off the package and passes user2.csv to the package (so
now path is user2.csv)

Is the text file source that client1 then sees now user2.csv
- because client2 changed it before the next step import process was
started??

I haven't figured out a way to test this yet and even if i do i'm not sure
if i trust it!

If it is potentially a problem can you think of a better way?

Thanks

Paul

pauly wrote:
Actually i just thought its probably a none question - i'm sure its
impossible to run 2 copies of a dts at the same time anyway!!

Nope it is perfectly possible to run the same DTS package in different
sessions

The paths you are passing are runtime specific and not persisted. On
startup of the package each client sees the design time value.



"pauly" <paulyateswithoutthespam (AT) hotmail (DOT) com> wrote

I tried running the same package in different sessions by using 2 copies of
enterprise manager (on different machines). The 2nd package waited for the
first one to end before starting itself.

Are you saying that if i call a dts package via code this doesn't happen?


Allan Mitchell wrote: