How do I configure SSIS logging to overwrite the log file?

Question

My SSIS package has logging configured with a SSIS log provider for text files, which works fine, but each time the package is run the log appends to the end of the log file. I want it to truncate the file and only keep the log from the most recent execution of the package, but I don't see an option anywhere to do that.

I've tried both file usage types (Existing file and New file) in the File Connection manager with the same results.

Answer 1

I suggest you to clear the text file before Executing the package, using Script Task under Event Handler, by firing the event "OnPreExecute". I hope this works.