SSIS Logging, File Connection Manager
I enabled SSIS Logging and I created a File Connection Manager. In the File Connection Manager, I chose "Create file" option. I specifically chose this over "Existing file" because I thought the "Create file" option would create the log file new each time the package is run, but it is appending to it. Am I not understanding this correctly? If I wanted a new file each time, do I need to add a separate package with File System Task to clean out the old logs?
July 23rd, 2008 9:55pm

This link should point you in the right direction: http://blogs.conchango.com/jamiethomson/archive/2006/10/05/SSIS-Nugget_3A00_-Dynamically-set-a-logfile-name.aspx
Free Windows Admin Tool Kit Click here and download it now
July 24th, 2008 2:01am

In addition to David's post, if you only want one file, you need to add a File System Task to delete the previous log file.
July 24th, 2008 3:35am

See this Article about implementing ssis logging various ways. http://pragmaticworks.com/Products/Business-Intelligence/BIxPress/ssis-logging-auditing-monitoring.aspx SSIS-Tutorials-FAQs | Convert DTS to SSIS | Document SSIS | SSIS Tasks | Real-time SSIS Monitoring
Free Windows Admin Tool Kit Click here and download it now
May 2nd, 2011 1:11pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics