SQL2000 lastest SPs

We have a large DTS that runs every night from midnight to 2:00AM. 99% of
the time there isn't a problem, but on occasion the job will be hung.
There will be no messages in the event log indicating the problem, no
notification since it never failed or completed.

How can we determine what is causing it to hang. This probably once or
maybe twice a month.

Do you have package logging set up? It is on package properties. You can
view the package by right clicking on the Local Packages node and clicking on
package logs. Look for steps that start and don't finish. One of those is
likely to be your culprit. Not all of them. Some steps are marked "started"
even though they don't execute. They are waiting to run.

If the erroring item is a data transformation, you can log the execution on
the last tab of the data transformation.

--
Russel Loski, MCSD.Net


[quoted text, click to view]