SSIS 2008 - Selectively turn on SQL Server Logging or Text File Logging

Question

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 fails

Has someone tried this before or do people have other recommendations


Thanks

Answer 1

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

Answer 2

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

Answer 3

:) 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