Modify the Event Log Source name for an SSIS package

Posted by Paul Kohler on Stack Overflow See other posts from Stack Overflow or by Paul Kohler
Published on 2010-03-08T01:13:11Z Indexed on 2010/03/08 5:06 UTC
Read the original article Hit count: 763

Filed under:

ssis

|

eventlog

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 :-)

© Stack Overflow or respective owner

Modify the Event Log Source name for an SSIS package

Posted by Paul Kohler on Stack Overflow See other posts from Stack Overflow or by Paul Kohler
Published on 2010-03-08T01:13:11Z Indexed on 2010/03/08 1:18 UTC
Read the original article Hit count: 763

Filed under:

ssis

|

eventlog

I have an SSIS package that logs to the Event Log (yes, the event log!)

The default "Source" of the log events is "SQLISPackage100" but I want it to be something like "AppName".

Event Type:      Error
Event Source:    SQLISPackage100
Event Category:  None
...
Description:
Package "Foo" failed.

I hope the answer is simple, but does anyone know how to change the text of the Event Log Source?

© Stack Overflow or respective owner

Related posts about ssis

SSIS packages incompatibilities between SSIS 2008 and SSIS 2008 R2

as seen on SQL Blog - Search for 'SQL Blog'
When you install SQL 2008 R2 workstation components you get a newer version of BIDS (BI Developer Studio, included in the workstation components) that replaces BIDS 2008 version (BIDS 2005 still live side-by-side). Everything would be good if you can use the newer version to edit any 2008 AND 2008R2… >>> More
Parsing flat files using SSIS : SSIS Nugget

as seen on SQL Blog - Search for 'SQL Blog'
Often when using SQL Server Integration Services (SSIS) you will find there is more than one way of accomplishing a task and that the most obvious method of doing so might not be the optimal one. In the video below I demonstrate this by way of an experiment using SSIS’s Flat File Source component;… >>> More
Introducing SSIS Reporting Pack for SQL Server code-named Denali

as seen on SQL Blog - Search for 'SQL Blog'
In recent blog posts I have introduced the new SSIS Catalog that is forthcoming in SQL Server Code-named Denali: What's new in SSIS in Denali Introduction to SSIS Projects in Denali Parameters in SSIS In Denali SSIS Server, Catalogs, Environments and Environment Variables in SSIS in Denali… >>> More
New SSIS tool on Codeplex – SSIS Log Analyzer

as seen on SQLIS - Search for 'SQLIS'
I stumbled across a new SSIS tool on Codeplex today, the SSIS Log Analyzer which was only released a few days ago. Whilst it is a beta release and currently only supports 2005 (2008 is promised) it looks quite interesting. It seems to be a fancy log viewer, but with some clever features and a nice… >>> More
New SSIS tool on Codeplex – SSIS Log Analyzer

as seen on SQLIS - Search for 'SQLIS'
I stumbled across a new SSIS tool on Codeplex today, the SSIS Log Analyzer which was only released a few days ago. Whilst it is a beta release and currently only supports 2005 (2008 is promised) it looks quite interesting. It seems to be a fancy log viewer, but with some clever features and a nice… >>> More

Related posts about eventlog

deleting eventlog

as seen on Stack Overflow - Search for 'Stack Overflow'
Hey, How can I delete a specific eventlog entry (say id 130 with source: Myprog) or delete all eventlogs from a specific source without deleting the whole eventlogs under "Application" folder? public static void deleteEvent() { string logName; if (EventLog.SourceExists(SOURCE)) … >>> More
Reading EventLog C# Errors

as seen on Stack Overflow - Search for 'Stack Overflow'
I have this code in my ASP.NET application written in C# that is trying to read the eventlog, but it returns an error. EventLog aLog = new EventLog(); aLog.Log = "Application"; aLog.MachineName = "."; // Local machine foreach (EventLogEntry entry in aLog.Entries) { if (entry.Source.Equals("tvNZB")) … >>> More
get-eventlog issue

as seen on Server Fault - Search for 'Server Fault'
I wanted to get a quick report of some log entries I saw on a server, so I ran: Get-Eventlog -logname system -newest 10 -computer fs1 | fl I got events back however the descriptions were all wrong. Here's an example: Index : 1260055 EntryType : Warning InstanceId : 2186936367 Message : The… >>> More
Access to Windows 7 log from a remote machine

as seen on Super User - Search for 'Super User'
I'm trying to access with EventViewer (from a Windows XP Prof) to a remote machine with Windows 7 (Seven). Before I started the Service "RemoteRegistry" I received an "Access Denied". After started the service I can connet to the machine Log (in EventViewer app) but when i clik on any log as "Application"… >>> More
logparser not matching on a LIKE pattern

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi I seem to have the strangest problem. I am using logparser to search an event log for some text that I know is there (i copied and pasted the string from the event into the sql search string). But the sql LIKE statement is returning a empty results. But other LIKE statments seem to be working file… >>> More