Logging Errors for DTS packages | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Logging Errors for DTS packages

Hi, I am facing logging errors for my DTS packages. I have enabled Logging in SQL server’s msdb database. It has table ‘sysdtspackagelog’ and ‘sysdtssteplog’ for logging. In the table ‘sysdtssteplog’ I got few steps with NO END TIME. Although there was a starttime and no error. The StepExecStatus was NULL. What does this corresponds to? The package which starts ON SUCCESS of this package also started with proper logs even this package was not successful. I could not find what does StepExecStatus=NULL with NO END TIME for DTS steps denotes and how a package which runs on successful completion of another package run even if the previous package could not do what it was supposed to do. Thanks for any help…..
Can you explain bit more on enabled loggin on MSDB database?
Have you enabled the DTS package logging by editing that particular package, have you referred to that log? Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
I have enabled Logging for DTS package in SQL Server, by checking the option Generate Logs in SQL Server in package properties-Logging Tab. When I saw the Log, there was No Error, No End time, but there was a start time.
I am using SQL server 2000 with service pack 1
What this DTS package suppose to do?
What is the reason for being in SP1 alone, SP4 is the latest on SQL 2000. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
The DTS package fires an SP on a remote machine….. We’ve been facing logging related problems so we will soon be upgrading our sql server installation with service pack 4….Is it needed to install service pack 2 and 3 before installing service pack 4?
No you can simply go to SP4 directly, but ensure to test it before applying on the production instance. Refer thruhttp://support.microsoft.com/kb/884525 SP4 README. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
]]>