Hi,
I would like to confirm regarding DTS package execution.

1. Multi Threading is possible in DTS package?
2. Simultaneously can we call same DTS package, in more then one DOS prompt?
If it is passable is their any effect on Global variable?

1 - Yes

2 - Yes

When executing a package, the first thing it does is load it into memory.
You can have as many copies in memory as you like. DTS is just a COM object
really. There is no synchronisation or communication between multiple
in-memory instances of the package.


--
Darren Green
http://www.sqldts.com
http://www.sqlis.com


"Rajesha" <Rajesha (AT) discussions (DOT) microsoft.com> wrote