DTS package editing

[sodakotahusker]

I have a DTS package with 135 tasks for copying data from tables in one database to another. I want a task that runs before the copy to empty the tables. I want another task that runs after the copy to massage the data. When I add the new tasks they both are executed after the Copy tasks. Kind of defeats the purpose of copying when your truncation job runs after you bring the data over.
How do I order the tasks so they run in the sequence I want.
Also each copy task has its own data connection. I am trying to change the connection property in this package which I've cloned on a new data to use a different server and database name. I have not figured out the technique for changing this so it works. i modified the existing connections to point to my desired locations but that does not seem to impact the tasks out there which are assigned to use those connections.
Is there any place where you can find documentation on how to use the DTS editor?

 

[AtomicWedgie]

Hello,

look at Workflow (On completion, On Success, On Failure).

Regards,

Atomic Wedgie

 

[SQLDenis]

Assuming you already create the workflows
If you right click on workflow you will see a couple of things, among them source step and destination step
Use that to manipulate the order of execution

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[sodakotahusker]

I looked at that. My problem is that I have 135 tasks. I don't want to have to map the sequence of each one of them. Is there anyway to group the tasks - so all the copy tasks run and then the next sequence is kicked in?

It is starting to look like I might have schedule two jobs - one to truncate the tables and the other to do my copying. And if I ever have to add another copy task - I'm looking at the problem again.