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)
 Task Order Modification

Author  Topic 

kjedrusiak
Starting Member

7 Posts

Posted - 2003-07-09 : 09:45:18
I have several Execute SQL tasks whos order I can control using Workflow.

I also have 14 Data Pump Task that are tied to the success of the last Execute SQL Task.

I need to control the order of the Data Pump tasks...as each step buildes on the prior. Right now it seems the go almost in the order they were created. I really need to shift one up a few places in the execution order.

How do I accomplish this? Can it be done without creating a set of connection objects for each step?

kjedrusiak
Starting Member

7 Posts

Posted - 2003-07-09 : 10:59:31
Never mind...figured it out.

Go to Top of Page
   

- Advertisement -