(somewhat) Social
« Are You Watching The Midnight DBAs? | Main | CLR Errors In Replication »
Tuesday
Sep072010

Disabling SSIS Logging To Event Log

Do you have a lot of SSIS packages executing in your environment?

Are you suffering from your Application Event Log filling up with Event IDs 12288 and 12289 letting you know that SSIS package have started and finished?

Is it difficult for you to find relevant events in your Event Log because of this?

Turn those pointless notifications off.

Open up the registry (careful now, you can do damage in here) and navigate down to:

HKEY_LOCAL_MACHINE -> SOFTWARE -> Microsoft -> Microsoft SQL Server -> 100 -> SSIS

You should see a key called LogPackageExecutionToEventLog. Change the value from 1 to 0 and enjoy a brand new lease of life in your Application Event Log.

PrintView Printer Friendly Version

EmailEmail Article to Friend

Reader Comments

There are no comments for this journal entry. To create a new comment, use the form below.

PostPost a New Comment

Enter your information below to add a new comment.

My response is on my own website »
Author Email (optional):
Author URL (optional):
Post:
 
Some HTML allowed: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <code> <em> <i> <strike> <strong>