SSIS: How to read error messages from a console app and send them by email SSIS: How to read error messages from a console app and send them by email Let’s say you have a SSIS package that runs a console app, everything works fine, but one day, the console app fails, and the SSIS package fails with a non helpful error message. You want to know what was the error, what data was involved and you want it be email Works with SSIS project in Visual Studio 2015 Simple console app in .NET 4.8 Steps Console app Create a console app for C# Replace the code in Program.cs with this: class Program { static int Main ( string [ ] args ) { try { string value = "a" ; //Output to StdOutput variable Console . WriteLine ( "Value to convert:" + value ) ; int i = int . Parse ( value ) ; return 0 ; //In console apps, normally returning 0 in...
Comments
Post a Comment