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.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s