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....