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.
| Author |
Topic |
|
GhantaBro
Posting Yak Master
215 Posts |
 Posted - 2009-02-26 : 16:56:28
|
| Hey Guys,We have a DTS Package in SQL 2005 (that was inherited from sql 2000) that has almost 70 tasks all jumbled up. Each task has a SP running. What I am planning to do is, create few SPs that runs related sps in a nested way and create a new DTS with less tasks. Also, we can run the tasks in a parallel way. The problem I have is I need to find out the order in which tasks runs quickly as looking at the DTS and noting them will take a long time (more than 70 tasks all jumbled up). Is there a way or a table where I can pull the order in which tasks runs in that DTS package? Guys any suggestion is appreciated.THanks a lot. |
|
|
|
|
|
DTS Package tasks execution