locked
SSIS - continue loop on error RRS feed

  • Question

  • Hello,

    I have a SSIS report moving excel files into a SQL DB.  The excel files get moved from a Input folder into an Archive folder as they get moved into the DB.  Everything is working fine.

    I recently added a Rejected folder to move error files with different formats.  I'm struggling to get the ForEachLoop to continue on error.  The file moves on failure into the Rejected Folder but then it stops running the loop.

    I've went into the Event Handler and set Propagate , OnError , Boolean, = False but it doesn't seem to continue the loop.

    Any help or direction would be greatly appreciated.

    Thanks,

    Tim


    x

    Monday, August 10, 2020 2:01 PM

Answers

  • Hi Tim,

    According to my test, we can use two methods to continue loop on error.

    Method 1: a.Please go to Event Handler and choose the failed component.

                      b.Then set the onerror variable Propagate as False.

                      c.We should execute the whole package but not just the Foreach Loop Container.

    Method 2: Please set the two properties of the Foreach Loop Container and the failed component.

                        a. ForceExecutionResult Success

                        b. MaximumErrorCount 0

    Best Regards,

    Mona


    ""SQL Server related"" forum will be migrated to a new home on Microsoft Q&A SQL Server!
    We invite you to post new questions in the "SQL Server related" forum’s new home on Microsoft Q&A SQL Server !
    For more information, please refer to the sticky post.


    Tuesday, August 11, 2020 2:49 AM

All replies

  • Hi Tim,

    According to my test, we can use two methods to continue loop on error.

    Method 1: a.Please go to Event Handler and choose the failed component.

                      b.Then set the onerror variable Propagate as False.

                      c.We should execute the whole package but not just the Foreach Loop Container.

    Method 2: Please set the two properties of the Foreach Loop Container and the failed component.

                        a. ForceExecutionResult Success

                        b. MaximumErrorCount 0

    Best Regards,

    Mona


    ""SQL Server related"" forum will be migrated to a new home on Microsoft Q&A SQL Server!
    We invite you to post new questions in the "SQL Server related" forum’s new home on Microsoft Q&A SQL Server !
    For more information, please refer to the sticky post.


    Tuesday, August 11, 2020 2:49 AM
  • thanks for your help!

    x

    Tuesday, August 11, 2020 12:11 PM