Ive been using the "execute sql task" to run my stored procedures, only to find that if I use the RAISEERROR this does not propogate out as a "failed" task so the DTS just continues on...
CREATE PROCEDURE A1 AS
RAISERROR ('An error occured...',10,5) WITH SETERROR
so running this DTS, A1 will continue onto A2 no matter what RAISEERROR i place in.
Funny enough, a SQL*Server generated error WILL result in a error and stop the DTS.
Any ideas? im not keen on replacing my tasks with Active-X jobs and checking return values it seems to totally defeat the purpose of the SQL task!?
Author of "SQL Server Backup, Recovery & Troubleshooting"
Author of "SQL Server 2k for the Oracle DBA"