• subscribe
December 07, 2009 12:00 AM

SSIS Logging Best Practices

What information should be logged, where should it be logged, and how should it be logged?
SQL Server Pro
InstantDoc ID #103213
Listing 2: Using the EventLog Class to Log Errors to Event Logs
if(! System.Diagnostics.EventLog.SourceExists(LoadName))
                {
                    System.Diagnostics.EventLog.CreateEventSource(LoadName,"Application");
                }
                StringBuilder PleaseSee = new StringBuilder();
                PleaseSee.Append( "Please see ");
                PleaseSee.Append(logPath.ToString());
                PleaseSee.Append(" for further details");
                System.Diagnostics.EventLog.WriteEntry(LoadName, ex.Message,System.Diagnostics.EventLogEntryType.Error);
                System.Diagnostics.EventLog.WriteEntry(LoadName, PleaseSee.ToString(), System.Diagnostics.EventLogEntryType.Error);


ARTICLE TOOLS

Comments
  • Bhudev
    2 years ago
    Mar 05, 2010

    This is what, I was looking for. I'm working one of major DW requirements on SSIS, where counting of packages can cross 100 mark. Source can be Web Site, Structural DB tables, Flat files & other formats, which will come from multiple applications. My manager asked to give common framework for Exceptional Handling & which will be better out of Exceptional Handling using SSIS Features vs Using Web Services or using C# APIs.

    As you have discribed why & why not in details, it was really helpfull to me.

You must log on before posting a comment.

Are you a new visitor? Register Here
  • SP1?
    I know there is a SP1 for SQL 2008 R2 available....and there is a "feature pack" as well... ...
  • SQL database mirroring
    I have SQL Server 2008 R2 Enterprise 64bit on Windows 2008 R2 Enterprise 64bit.  Each SQL Server has...
  • Dell Compellent Disk Drive
    Does anybody has experience with Dell Compellent Disk Drive? Basically, this system manages all disk...
  • Sql server performance tuning
    I need to find a tool that help me to optimize sql server,queries,improve the performance and solve ...