Link to home
Start Free TrialLog in
Avatar of carecorejen

asked on

SSIS Task with 2 preceding tasks never runs

I have a SSIS Package that stops running at a task that has two preceding steps.

For example, I call a webservice and after that I have a script task that checks the result of the webservice for a bad return value, this task fails on the bad return value.  On failure, I execute a send mail task and then on success of my send mail task, I move onto the next step.  On success of the script task, I just move onto the next step.  The "next step" never executes.  And there is no error.

In the attached file "Get Data from CNET_Documents" never executes.
Avatar of drydenhogg

slight guess, but on the script task, check the FailPackageOnFailure and FailParentOnFailure settings. See if you are propagating the failure up.
Avatar of ibrusett
Flag of Italy image

Link to home
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of carecorejen


Worked like a charm!  Thanks!