SSIS Loops that do not fail

By default, in a Loop container, if the contents of that loop fail, then the whole container is failed at the same time. Every now and then I need to create loops that do not fail when the contents fail – for example because failure is permitted or handled within the container.

The way to allow a loop to continue even if its contents have failed is to set the ForceExecutionResult property to Success, and every iteration of the loop will be treated as successful, regardless of what happens during the loop.

I’ve knocked up a very quick sample package demonstrating this, which can be downloaded here.

Read More