Which variables return warning number and description in OnWarning Event Handler? RRS feed

  • Question

  • Hi All,

    When there's an execution error in our SSIS 2012 packages, we use the OnError event handler to run a stored procedure that logs the error using the variables System::ErrorCode and System::ErrorDescription to a user-defined table.  Now we want to also log SSIS warnings to that same table.  Which variables do I use in the OnWarning event handler?  I don't see any system variables with "warning" in the name.

    We don't want to use SSIS built-in logging because those records wouldn't get written to our user-defined table.

    Eric B.

    • Edited by SQL Server dude Wednesday, July 11, 2018 4:05 PM corrected typo
    Wednesday, July 11, 2018 4:02 PM


All replies