I have a package calling a stored proc PROC1, itself calling another
proc PROC2, calling a third proc PROC3.

Each procedure returns -1 on success and 0 on error
Each Procedure raises a raiserror('adhoc message',16,1) on error

Something goes wrong in PROC3 which is detected by PROC2 (through
@@ERROR)
PROC2 raises and error and return 0
PROC1 detects the problem (because of returned 0) and raises an error
itself.

The SQL Task does not seem to notice the error and carries on as if
everything was fine...

Question: what could make this SQL Task ignore the error?

Usually, my errors are triggered by a procedure at level 2, not 3, and
DTS detects the error properly.


Thanks for your help!


Eric