Raiserror within a SQL Exec Task

• P@

  Ten Centuries

  Points: 1170

  More actions

  November 22, 2007 at 9:51 am

  #121124

  Hello SSISers,

  I would like to retrieve the error message raised by the T-SQL Raiserror() within SSIS.

  Here's a example of what I would like to do:

  Create procedure sp_test

  As

  Begin

  Raiserror('Custom error message', 16, 1)

  End

  Go

  In SSIS I have a Exec. SQL task that run the previous stored procedure.

  When I execute the package, the task fail as expected but the error retreived by the OnError event is:

  Executing the query "EXEC procedure sp_test" failed with the following error: "Exception from HRESULT: 0x80040E14". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.

  Is there a way to retrieve the 'custom error message' message instead of the « Exception from HRESULT : 0x80040E14 » message ?

  Thanks in advance,

  Patrick

  edit: translated the error msg

• Powichrowski Marek

  Hall of Fame

  Points: 3483

  More actions

  November 22, 2007 at 10:50 am

  #753445

  Please translate it to english.