Viewing 2 posts - 1 through 3 (of 3 total)
Update....
I found a link - (http://www.sqldev.org/sql-server-integration-services/raiserror-does-not-cause-sql-task-to-fail--why-5333.shtml)
suggesting to change the SSIS connection mgr to ADO.net.
I changed from OLE DB & error conditions detected in csp's are now correctly setting...
October 1, 2010 at 3:40 pm
#1230580
Upon further research I have determine that under error condtion 2 - the SSIS task does receive the error code in the @rc variable however it now appears the RAISERROR...
October 1, 2010 at 12:44 pm
#1230442