Returning error messsage

A

AJ

H i Guys,
I have a custom task which gets the error from the steps of DTS
package. It uses the method GetExecutionErrorInfo to get the error. But
I am not able to get the error back from a SQL Task which runs a stored
procedure in SQL Server Database.

Also even if the stored procedure executes successfully can i make this
method return a error value.
A quick help will really be appreciated

Thnx in advance
AJ
 
Top