Post reply

DTS packages active or inactive

  • March 15, 2011 at 4:29 am

    #236750

    Hi

    How to identify if the dts packages active or inactive?

    active in the sense used or not

    How to identify, when did the dts packages run?

    It would be very helpfull, if anybody answering the above questions.

    Regards

    Balaji G

  • March 15, 2011 at 4:55 am

    #1298752

    I'm going through this at the moment, and my best solution so far is to open up every DTS package, view the package properties (on the toolbar or right click on any white-space in the package), go to the "Logging" tab, and then choose to enable logging to your local database server. Click OK, and save the package.

    Then, you can go to MSDB and look at the package history:

    SELECT * FROM msdb.dbo.sysdtspackagelog

    If anyone has a better idea, I'd love to hear it, but this seems like the best way of knowing exactly when each package is run.

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

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