DTS Troublshoo need help | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

DTS Troublshoo need help

Hi,
Need help in troubleshooting the DTS. The last night I execute the package from DTS–Local Packages. Generally it takes around 12 hrs. Now in the morning when I logged in the server, I am not able to see any execution of DTS. Could you please help me to troubleshoot that how to check the status of DTS, wither its running or what happend….. Regards
Ashish Kuriyal

hi, r u executing the DTS by job schedule?
if so then view job history
or…if u have enabled logging of DTS packags then check the [package logs..] for detail
where u will find 4(success) and 0(running) for status.

Are u sure about that. Because if I check the Log then there are lot of entries of the Last version in the single DTS which shows status as 4. So are the steps still executing…
Ashish
I mean 0
it may be in the condition of 4 with RED X MARK…meaning failed
or 4 with BLUE TICK MARK…..meaning step completed successfully
or 0…menaing executing
OK great. Thanks a lot. Is there no entry similar to this in MSDB databases’s tables
Is it possible to stop those steps which are not required and showing as executing status in different logs of same version of DTS… Ashish
]]>