Any way to disable Information Events? Is this an SSIS defect, or just an oddity of how it implements Windows Events?
Windows Event:
Source: SQLISPackage
Type: Information
Event ID: 12288
Description: Package "XXXXXX" started.
Event ID: 122289
Description: Package "XXXXXX" finished successfully.
faype02 wrote:
I enabled Windows Events for OnError, OnTaskFailed, OnWarning for my package and subelements. However, even if no errors occur, I still get Informational Events generated even though those are disabled for all modules and packages. Any way to disable Information Events? Is this an SSIS defect, or just an oddity of how it implements Windows Events?
Windows Event:
Source: SQLISPackage
Type: Information
Event ID: 12288
Description: Package "XXXXXX" started.Event ID: 122289
Description: Package "XXXXXX" finished successfully.
Oh yeah, I can reproduce that. Weird - I don't think those should be there.
[Microsoft follow-up] Is this a bug or by design?
-Jamie
|||It appears that this is by design see:
http://www.microsoft.com/technet/prodtechnol/sql/2005/mgngssis.mspx
In section on "Custom Log Provider" it says:
"To facilitate operations management, SSIS packages always write some basic logging information to the Windows event log, even for packages that do not incorporate logging. SSIS packages write events for package initiation and package completion and they can be identified using either the SQLISPackage or SQLISService event sources."
It would be a lovely option to be able to disable this.
Regards
|||So if I have a package that executes every 30 seconds, I have no control over thousands of "package start" and "package finished" log events per day?There must be a way to intercept these with an event handler in the package - how would this be done?
No comments:
Post a Comment