SSIS: If a task fails, how do I make the package continue to the next step (and not fail) but log the error
Posted on 2008-10-06
I have an SSIS package on SQL Server 2005. It has many steps and several variables, all working ok.
Everything works fine, until a step fails. The whole package stops. I dont' want that to happen. Instead, if the step fails (it's an Execute SQL step, and I'm running a stored proc that does not return anything, but there is a TRY..CATCH Exception in there which causes the failure of the package), then I want to log the error and carry on.
I have a precedence constraint coming from the step to the next step. A "success" constraint path, and a "failure" constraint path.. but the failure step is never reached even though the step is indeed failing.
I have set FailaPackageOnFailure to True on the step itself, but still no joy.