Post reply

Table/view where DTS Packages Logs are being stored

  • February 18, 2009 at 7:25 pm

    #77257

    Hi,

    Does anyone know whether the DTS Packages logs are being stored in a view or table? If it is, what view/table is it, so I can view at once when my DTS package run the longest time and to compare each run duration.

    Regards,

    Renan

  • February 19, 2009 at 3:21 am

    #946535

    sysdtspackagelog table in msdb database

    --Ramesh

  • February 19, 2009 at 9:33 am

    #946854

    If your packages are stored in SQL Server, you can also view the log info by right-clicking on the package in the "Local Packages" list in Enterprise Manager and selecting "Package Logs...".

    Greg

  • February 19, 2009 at 7:57 pm

    #947299

    Thanks Ramesh, for the answer.

    Hi Greg, thanks as well for additional input. That's what we are currently doing.

    Regards, Renan

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

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