I keep reading about the flexibility of SSIS logging, but I'm running
into an area that doesn't seem so flexible. I want to have one text
log file contain only errors from my package and another text log file
that has many more events.

While it is easy to configure two text log providers on the Configure
SSIS Logs dialog, the problem is when you go down to the Details tab.
Each event checked on or off appears to apply to ALL of the log
providers. That is, if I check off PostExecute event when I'm
configuring my errors-only log, then go back to the Providers and Logs
tab and select my comprehensive text log, when I switch back to the
Detail tab I find PostExecute has been checked off for this provider as
well.

Am I misunderstanding, is it a GUI issue, or is there no way to have
dissimilar events log for different providers at the same package
level?

Vince

Hello vince.iacoboni (AT) gmail (DOT) com,


So what i think happens is that when you look at the detilas tab of the logging
it says "select the events to be logged for the container". This to me means
that individual containers regardless of amount of log providers and type
of log providers assigned to the container will all log the same info.

You can have different providers on different executables logging different
info about that executable though.


Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com