SSIS: do not fail foreach loop if package fails?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

meska - 25 Jul 2008 08:30 GMT

Hi,

i have a foreach loop that loops through ADO recordset.

In that loop i have a execute package task (lets call it SubmitData), which
executes another package.

If at one iterration package SubmitData fails, foreach loop would continue?
Because now it fails after first packages failure?

I though tat using FailParentOnFailure would help - but no. I do not want to
increase maximum error count, as in foreach loop i migh have as many as 10
000 records ( or even more). I simply want that execution of foreach would
loop through all records in recordset, despite the output of SubmitData
package. How can i do that?

Reply to this Message

Todd C - 25 Jul 2008 13:37 GMT

Look for the property ForceExecutionResult (Under Misc category).

You can set the task to always report to its parent container that it
succeeded, regarless of what actually happened inside it.

HTH

Signature

Todd C

[If this response was helpful, please indicate by clicking the appropriate
answer at the bottom]

> Hi,
>
[quoted text clipped - 11 lines]
> loop through all records in recordset, despite the output of SubmitData
> package. How can i do that?

Reply to this Message