Is it possible to dynamically change the way SSIS packages log events to SQL Server (or the file system etc)?
I would like to have different events logged based on the environment the package is running in. For example, in DEV I would like to log more detail of the package execution than I would in PROD.
SSIS has a configuration interface that I control many aspects of the packages during run time - such as connections, variable values, and component property settings.
Is there a way of doing the same thing for package logging - where SSIS would look at a configuration file and get the events to log based on the file it is looking at.
DTExec has the /L command line switch which tells the package what log provider to use at execution time - but it does not seem to support what events to log - just the provider to use.