SSIS 2012 Centralized Error Capture

• cdun2

  SSCertifiable

  Points: 7893

  More actions

  March 26, 2013 at 2:41 pm

  #275677

  I'm using SSIS 2012. I'm trying to collect all package errors as a formatted string, and communicated those from an OnError event (at the control flow level) as an email.

  I have found examples here:

  http://agilebi.com/jwelch/2008/01/15/handling-multiple-errors-in-ssis-revisited/

  http://agilebi.com/jwelch/2007/05/05/handling-multiple-errors-in-ssis/

  The only problem is, these examples are in vb.net. I haven't found anything like this done in C#.

  I've tried vb.net to C# conversion tools, but I receive errors when I attempt the conversions.

  How can I implement these same solutions in C#?

  The script task I am writting is configured for .NET 4.0

  Thanks.

  csdunn1us