Logging in SSIS
Hi:
Just implemented logging on my package, and the type of logging is to a text file. Any ideas on where should i store my log folder/file, so when I do my build and deploy, I end up moving the folder as well. Do I have to manually do that? How would that work? What if I save the log file outside of my project folder? Where is the log folder/file path specified? Thanks.
January 24th, 2007 5:41pm
When you set up the logging you created a connection manager to point to the log file right? Then all you need to do is to make sure that connection manager is properly configured in the new environment; meaning that the path you specified exists and the user executing the package has access to it. You could use package configuration to set up the connection managers at run time; eliminating the need of opening and editing the packages each time you deploy them to a different environment
Free Windows Admin Tool Kit Click here and download it now
January 24th, 2007 6:01pm
Its a bit of a digression ... but I have some ideas here on where you could storeyour logfiles:
Common folder structure(http://blogs.conchango.com/jamiethomson/archive/2006/01/05/SSIS_3A00_-Common-folder-structure.aspx)
-Jamie
January 24th, 2007 7:16pm
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:13pm