• Hi John Rowan!

    I have a similar problem. I did what you said about the Propogate variable = false on all tasks inside the foreach container. But the execution still halts, it doesn’t go to the next item iteration of the loop. Am I missing something?

    =======================================================================

    ForEach Loop

    DataFlowTask(OnErorr Propogate=false)

    ==>success>

    DataFlowTask(OnErorr Propogate=false)

    ==>success>

    FileSystemTask(OnErorr Propogate=false)

    ==>success>

    SendEmailTask(OnErorr Propogate=false)

    Problem: My SMT could fail with bad email address and to me that’s ok. For example: the first item in the collection has a bad email. I have a OnError event SendeEmailTask here to handle when the task fails. It executed the OnError SendEmail task fine. Then, the SQL task was executed. Then the whole package failed. It never went to the next item in the collection. I want my package to still go on to the next item in the collection but it stops the whole package. I added the propogate to all the tasks in the foreach container like you mentioned to do, but it stops on the first item of the collection because the email is bad.

    ==>success>

    SQL Task

    =======================================================================