Post reply

SQL 7 : Log All Dts packages

  • March 23, 2006 at 9:43 am

    #67401

    Good afternoon folks,

     I'm looking for a way to track all DTS packages executed on a server (be it scheduled, run via a java app whatever)

    I was looking along the lines of setting up the error log in all the packages programmatically, whilst this is easy to do in sql 2000 (code exists on this site) I can't get the bugger working on sql 7.

    Can anyone help with some sample code or a better way to achieve my aim?

     

    Thanks in advance for any and all help

     

  • March 23, 2006 at 10:57 am

    #628419

    Setup execution logging on your packages to log to SQL. The results of every execution will log to sysdtspackagelog and sysdtssteplog tables in the msdb database.

    -Mike Gercevich

  • March 23, 2006 at 2:27 pm

    #628467

    I have set up a profile instead.

     

    Does the job but will require a lot of data mining!

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply