Does RAISERROR terminate an SSIS package

[RRinTetons]

If an SSIS package has an EXECUTE SQL task in it that raises an error, what happens to the package execution? Is it cleanly terminated? Or, something else?

I'm testing to try to figure it out, but thought see if anyone here has a definitive answer.

-
Richard Ray
Jackson Hole Mountain Resort

 

[RRinTetons]

The answer at first blush is NO. But there is probably a way to return the error and halt the package.

Onwards.

-
Richard Ray
Jackson Hole Mountain Resort

 

[pmbtech]

We use RAISERROR in all our procs that are used by our SSIS pkgs. The Error is bubbled up to SSIS and from there we can halt or continue the package. The TASK that called the proc will go into error state and anything below that task will not run.
In order to halt the entire package, all our procs are called from a wrapper proc that checks the "status" of the package, if it is in error status we raise and error to halt any new tasks that start up after the initial failure.
Even though the other braches in the package can probably run w/o incident unless they join back up the stopped branch, we found it easier to just let any running tasks finish and then not allow any new ones to start so we have a clean re-start point when the error is addressed.