Post reply

truncating DTS log files on a regular basis

  • September 26, 2005 at 9:30 am

    #69650

    Hi Gurus,
     
    I have a DTS package on my production box. It is scheduled to run every 5 mins. I have enable package logging. But the log grows at a faster rate and my user is concerned about that. He wants the log file to be truncated on a regular basis. My question is  - is there a way of truncating that on a regular basis?.
     
    Any help is appreciated
    Thanks in advance


    Helen
    --------------------------------
    Are you a born again. He is Jehova Jirah unto me

  • September 26, 2005 at 10:15 am

    #593059

    Helen,

    Here's an ActiveX Script that will overwrite the log each time the package runs.

    Greg

    http://www.sqldts.com/default.aspx?240

    Greg

  • September 26, 2005 at 5:12 pm

    #593155

    If you're logging to SQL Server you can use the sp_dump_dtspackagelog stored procedure in the msdb database to remove package log. It accepts a package name, package id, package version id or lineage indentifier (specific execution).

     

    --------------------
    Colt 45 - the original point and click interface

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

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