开发者

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

My SSIS package has logging configured with a SSIS log provid开发者_StackOverflow中文版er 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.


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.


In Flat file destination component, please tick the overwrite data in the File to truncate the file and only keep the log from the most recent execution of the package

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜