Hi all
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...
ie.
A1 -----success----A2---->etc---->
CREATE PROCEDURE A1 AS
RAISERROR ('An error occured...',10,5) WITH SETERROR
GO
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!?
Cheers
Chris.
Chris Kempster
www.chriskempster.com
Author of "SQL Server Backup, Recovery & Troubleshooting"
Author of "SQL Server 2k for the Oracle DBA"