February 18, 2003 at 3:08 pm
Is there a way to tell how long a DTS package took to complete?
February 18, 2003 at 4:42 pm
If you are on SQL 2000, you can turn on Package Logging. Then you can get timings on package and step execution from the msdb database.
sysdtspackagelog - cotains package execution details
sysdtssteplog - contains step execution details
Thanks
Phill Carter
--------------------
Colt 45 - the original point and click interface
February 19, 2003 at 4:52 pm
how do you turn on package logging? when i try to go view the log for a package, i get an empty pull-down list.
February 20, 2003 at 4:41 pm
Bring up the package properties and select the "Logging" tab. Then you can specify a server to log to.
Thanks
Phill Carter
--------------------
Colt 45 - the original point and click interface
--------------------
Colt 45 - the original point and click interface
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply