Link to home
Start Free TrialLog in
Avatar of carecorejen
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.
SSISIssue.pdf
Avatar of drydenhogg
drydenhogg

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

Link to home
membership
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

ASKER

Worked like a charm!  Thanks!