Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Parallel DTS

Author  Topic 

nemohm
Yak Posting Veteran

69 Posts

Posted - 2005-08-31 : 14:48:41
Hi,

Is it possible to run DTS packages in parallel (simultaneously)?

Thx,


AjarnMark
SQL Slashing Gunting Master

3246 Posts

Posted - 2005-08-31 : 16:26:45
DTS packages can be scheduled to run at any time, and other DTS packages can be run at the same times. You can also start a DTS package using the DTSRun command at any time. Within a DTS package, the tasks execute in parallel unless guided by Workflow processes.

What are you trying to accomplish? Do you want the DTS package to somehow spawn its own sibling processes? I don't think that will happen. And you probably don't really want the same DTS package running multiple times at once because that would likely cause all kinds of data confusion.

---------------------------
EmeraldCityDomains.com
Go to Top of Page
   

- Advertisement -