MS SQL Server DTS - DTS, msdb and the case of the missing statistics

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

DTS, msdb and the case of the missing statistics

Elliott Segelbaum via SQLMonster.com

2005-09-29, 9:24 am

I need to get some stats from a parent and child DTS package out of msdb.

When I check sysdtspackagelog, I see that both packages were run completely.
(good)
When I check sysdtssteplog, I see that all steps for both packages ran
completely. (also good)
In sysdtssteplog, I see the step that executes the child package
(DTSExecutePackageTa
sk_1)

So here are my questions:

1) How can I give my DTSExecutePackageTas
k_1 a more descriptive name?
2) How can I relate the execute package step to the record in
sysdtspackagelog that shows the execution of the child? (I want to run a
query that relates parent and child tasks)
3) why is there never anything in sysdtstasklog?
4) why is there no good documentation on this stuff anywhere?

Thanks,
-Elliott

Sponsored Links