DTS Log Purge

• mssql_rules

  SSCrazy

  Points: 2783

  More actions

  February 23, 2004 at 10:33 am

  #83836

  Does anyone have a script to purge DTS package logs for logs older than a week. I remember reading about COM object interface to DTS packages or a handful of tables in MSDB that store the info. I was wondering if someone already has the script so I do not have reinvent, since it seems such a common task..

  thanks

• Allen Cui-55137

  SSC Guru

  Points: 51650

  More actions

  February 23, 2004 at 11:57 am

  #495198

  have a look on table sysdtspackagelog in MSDB.