Have Geek Brain

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

My SSIS package has a log configured with the SSIS Log Provider for Text Files, which works great, but every time the package runs, the log is appended to the end of the log file. I want it to truncate the file and only keep a log from the most recent batch execution, but I don't see a way to do that.

I've tried using both types of file usage (existing file and new file) in the connection manager with the same results.

+2


a source to share


1 answer


I suggest you clean up the text file before executing the batch by using the Script Task in your event handler by enabling the "OnPreExecute" event. Hope it works.



+1


a source






More articles:


All Articles