Modify the Event Log Source name for an SSIS package
- by Paul Kohler
I have an SQL Server integration Services (SSIS) package using the standard Event Log provider (yes, the event log! I know we can use SQL etc...)
The default "Source" of the log events is "SQLISPackage100" but I want it to be something like "AppName" so that the errors are more visible between the different packages when viewing the event log (also for MOM use).
Event Type: Error
Event Source: SQLISPackage100
Event Category: None
...
Description:
Package "Foo" failed.
I hope the answer is simple, I simply cannot find it, but does anyone know how to change the text of the Event Log Source name to something more meaningful?
PK :-)