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