SSIS 2008 - Selectively turn on SQL Server Logging or Text File Logging
I use an xml config file to set the "LoggingMode" property on or off for my master/child packages. I am using a SQL Server Log Provider and a text file log provider. Is there a way I can choose to only have either of the two log providers at run time using dtexec.The idea being, use SQL Server Log Provider for normal logging and only use the text file log provider to trouble shoot when the SQL Server Log Provider failsHas someone tried this before or do people have other recommendationsThanks
November 4th, 2009 9:53am

HI decent Good question even i'd like to know more on this .. for now what i can suggest is the programming way ...... logging by the script task .. have a LogMode variable in package . configure this variable(LogMode) by which ever ssis configurations. Use LogMode variable in script task as readonly variable and code all ur logging stuff in script task but still i'd really like to know if there is any short cut way of the logging option selection short cut if available ... _______________________________________________________________________________ Please mark post/s helpful / answered if they answer ur query -- kunal
Free Windows Admin Tool Kit Click here and download it now
November 4th, 2009 10:31am

Hi Kunal,Thanks for the reply. Yes, that's an option but that seems to be more like custom logging.I was hoping there's an inbuilt SSIS feature.To provide a bit more information, I can get the logging to work manually by going to the Configure SSIS Logs Window and unchecking the box next to one of the Log Providers which results in only the selected type of logging being logged. Just wondering if the same can be achieved via command line. I've tried looking at the underlying xml code to work out what property gets updated but in vain.Thanks
November 5th, 2009 1:40am

:) AFIK there isnt any option but you can always look for work arounds ... modify and add , enable logging option programmatically then execute the package .... I am just throwing options for u ... short and easy solution am still looking for it :) hope that helps _______________________________________________________________________________ Please mark post/s helpful / answered if they answer ur query -- kunal
Free Windows Admin Tool Kit Click here and download it now
November 5th, 2009 1:54am

I dont think this is possible what you asking 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
May 2nd, 2011 1:14pm

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

Other recent topics Other recent topics