Discussion:
Ignore errors on Execute Package task in SSIS
(too old to reply)
CraigHB
2009-03-30 14:58:01 UTC
Permalink
In an SSIS package, I have a For Loop Container task with the EvalExpression
set to true (so that it runs forever). If any tasks inside the For Loop
Container fail, then the package must fail -- except for the Execute Package
task (that calls a child package). If that fails, then the parent package
should move onto the next task.

I tried setting the MaximumErrorCount of the Execute Package task to 0, but
that didn't help. I tried setting the MaximumErrorCount of the For Loop
Container task to 0, but that ignores the errors of all the tasks within the
For Loop Container task.

Any idea how I can ignore errors on only the Execute Package task -- within
a For Loop Container.
Todd C
2009-03-30 16:01:03 UTC
Permalink
Have you tried messing with the properties of the task(s) inside the loop:
FailPackageOnFailure
and
FailParentOnFailure
?

Sounds like they would be quite useful in this situation!
=====
Todd C
Post by CraigHB
In an SSIS package, I have a For Loop Container task with the EvalExpression
set to true (so that it runs forever). If any tasks inside the For Loop
Container fail, then the package must fail -- except for the Execute Package
task (that calls a child package). If that fails, then the parent package
should move onto the next task.
I tried setting the MaximumErrorCount of the Execute Package task to 0, but
that didn't help. I tried setting the MaximumErrorCount of the For Loop
Container task to 0, but that ignores the errors of all the tasks within the
For Loop Container task.
Any idea how I can ignore errors on only the Execute Package task -- within
a For Loop Container.
CraigHB
2009-03-30 16:32:01 UTC
Permalink
Yes, Todd -- that's it. I set the FailPackageOnFailure to true for the tasks
that I want to cause the package to stop if they fail. Thanks!

Loading...