I have a DTS package that takes 5 hours to run. The job number is a
package parameter. We need to run two jobs at the same time with two
different job numbers. How can I set up the DTS package so that I can
start two instance at the same time?

Thanks,
Yi

You can run multiple instances of a pacakge without any extra effort. Just
start a second one.

You will need to ensure that any common resources do not conflict. Don't try
and create two tables of the same name in the seme SQL DB for example.
Nothing special, just the same as trying to run the same query in two
sessions of Query Analyser, common sense I hope.


--
Darren Green
http://www.sqldts.com
"Yi" <huskerchen (AT) hotmail (DOT) com> wrote