A quick post today – I received this question from a customer earlier today, and it took me a little while to figure it out.
We have a number of packages that use a SQL Server logger. We want to turn logging off, but don’t want to modify all of our packages. Is there an easy way to disable logging for individual packages?
Why yes, yes there is.
Packages have a http://msdn.microsoft.com/en-us/library/microsoft.sqlserver.dts.runtime.dtscontainer.loggingmode.aspx which controls their logging behavior. The setting has three values:
| UI Value | Numeric Value |
| UseParentSetting | 0 |
| Enabled | 1 |
| Disabled | 2 |
Usually this value is set through the logging UI -
It can also be set through configurations, or by using /SET on the command line. Setting LoggingMode to 2 will disable all logging done by log providers in your package.
dtexec /f "C:\Package.dtsx" /set "\Package.Properties[LoggingMode];2"
Note, logging messages will still be displayed on the console – you can control these with the http://msdn.microsoft.com/en-us/library/ms162810.aspx .
