William E. Booth
2010-04-06 12:52:59 UTC
Hello all,
I have a execute sql task in a container with other tasks. This is all the task has in it DECLARE @RC int
EXECUTE @RC = TruncateTables
The container has a OnError event handler that sends a email.
How is the best way to handle a error in the stored procedure? I do not seem to be able to get the SQL error code or description.
Thanks in advance for any help.
Bill
I have a execute sql task in a container with other tasks. This is all the task has in it DECLARE @RC int
EXECUTE @RC = TruncateTables
The container has a OnError event handler that sends a email.
How is the best way to handle a error in the stored procedure? I do not seem to be able to get the SQL error code or description.
Thanks in advance for any help.
Bill