Hi, Happy New Year

There are two very basic options. The first is to generate a DTS package that performs all the tasks you need, alternatively, you could split the tasks into smaller DTS packages and schedule them as ‘Jobs’ (under management folder (if using 2000)).

In both options you have a precedence order so you can start one task when the other has finished or stop if it fails.