How to keep For Loop Container continue on error?

• Jobs90312

  Mr or Mrs. 500

  Points: 537

  More actions

  October 27, 2022 at 1:14 pm

  #4105325

  Hi all,

  So I found a solution of a problem I was having with For Each Loop Container in my SSIS package.

  If error was received on any of the task inside container the package was failing instead of going to next iteration.

  The solution found here: https://www.mssqltips.com/sqlservertip/3575/continue-a-foreach-loop-after-an-error-in-a-sql-server-integration-services-package/

  is to create event handler on error and it will continue through the error to next iteration. This solved my problem.

  But it doesnt seem to work for the For Loop Container. How do I keep the For Loop going to next iteration if error is received on previous? Any guidance would be appreciated....

• Site Owners

  SSC Guru

  Points: 80342

  More actions

  October 28, 2022 at 2:10 pm

  #4105896

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.