SQL Server Performance

Logging Errors for DTS packages

Discussion in 'SQL Server DTS-Related Questions' started by nareshb, Jun 15, 2007.

  1. nareshb New Member

    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.....
  2. satya Moderator

    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.
  3. nareshb New Member

    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.
  4. nareshb New Member

    I am using SQL server 2000 with service pack 1
  5. satya Moderator

    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.
  6. nareshb New Member

    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?
  7. satya Moderator

    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.

Share This Page