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)
 Change Execution Order in DTS Package

Author  Topic 

mevasquez
Starting Member

1 Post

Posted - 2005-04-05 : 16:34:55
How do you change the execution order in a DTS package. I have created a DTS package and forgot to add a task at the beginning. This task has to be run successfully before continuing execution of the other tasks. I had created this task in another package. I was wondering if I could just copy the tasks in one DTS Package to another and then just have the ability to change the execution order.

TIA
Mike V

jen
Master Smack Fu Yak Hacker

4110 Posts

Posted - 2005-04-07 : 02:43:04
you can edit one of the existing package and re-arrange the work flow

or call the next dts package to be executed (execute package task)

--------------------
keeping it simple...
Go to Top of Page
   

- Advertisement -