DTS Simple Question

I am just starting to learn DTS.
If I set up in a DTS package a series of 5 independant processes, each of
which Deletes rows out of it's respective table and then loads their
respective flat file into those tables.... Will all of these run
concurrently? I have them all tied to the same connection object, but that
should not prevent them from running concurrently...wil it?Jim,
Yes it will. if they use the same connection, it will prevent them from
running concurrently.
You can notice it in DTS Designer, when moving huge amount of data between
source and target using the same connection. The transformation steps
(datapumps) will run in sequence no matter if they were setup to run
concurrently.
AMB
"Jim Heavey" wrote:
> I am just starting to learn DTS.
> If I set up in a DTS package a series of 5 independant processes, each of
> which Deletes rows out of it's respective table and then loads their
> respective flat file into those tables.... Will all of these run
> concurrently? I have them all tied to the same connection object, but that
> should not prevent them from running concurrently...wil it?
>|||http://www.codeproject.com/useritems/DTS__VBNET_.asp