how to do transaction for each loop separately inside foreach loop RRS feed

  • Question

  • I have a foreach container inside that lots of operation happening.

    I want if something fail in one row it only fail that row and and move to next row.

    I want my package to not stop when some error happen only that particular row will fail and don't stop my loop and move to next iteration.

    e.g. If there is 5 iteration and there is some error in 3rd iteration then all four iteration persist in database and 3rd iteration rollback and not block execution of other iterations.

    my foreach is something like that

    prakash kumar jha

    Monday, May 11, 2015 7:02 AM