You can set the task property ForceExecutionResult to Success and MaximunErrorCount=0 You can find solution here: https://www.mssqltips.com/sqlservertip/3575/continue-a-foreach-loop-after-an-error-in-a-sql-server-integration-services-package/