Post reply

How do I get a SSIS package log file to overwrite itself

  • July 14, 2006 at 9:53 am

    #171590

    I am just starting to work with SSIS.  I configured a log file for the package but every time I run the package, it appends the events onto the end of the log file. Is there a way to get this to overwrite the entire log file?  I couldn't find anything.

    Thanks,

    John

  • July 17, 2006 at 8:00 am

    This was removed by the editor as SPAM

  • July 19, 2006 at 10:09 am

    #650160

    If you use a flat file destination, in the properties window under 'custom properties' select True for the 'Overwrite' property.

    M.

  • July 19, 2006 at 12:15 pm

    #650191

    Marcus,

    Thanks for the reply but I may not be explaining myself correctly.  I am doing a load into a SQL table.  I turned on logging for the entire SSIS package.  When I configure it, it initially gives me the option to use an existing file or create a new file.  Whenever I rerun this package, I want it to overwrite the file I initially set it to use.  Does that make sense?  I am not sure if this is possible or not.

    THanks,

    John

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

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