I need the help from anybody who knows how to create a sequential DTS, because I need to make a DTS that runs every half hour for different organizations but sometimes the DTS of the second organization starts before the DTS of the first organization ends and that makes that the data from one organization ends in the file of the other organization so if anybody knows how to program the DTS to pause until the last one ends please let me know.

Thanks,
Edgardo Cabrera.

If each organisation has a seperate DTS package you could have one master DTS package that executes each of the other DTS packages on completion of the last?

Use the 'Execute package task'

Don't know if there is a better way of doing it?

Stu