Sign in
 

none
Error Handling to send error row in another table

 > 

    Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    hi all

    I need to do some error handling based on condition like.

    I have one datafolw task

    Source:Select top 10 email,id from customer

    I can not use redirect option .(because I have one trigger at destination).

    Now I need if any of row is not inserted at destination (Failed).

    Then email address will insert in another table either based on Event handler and all.

    I tried wiith Event handler with datafolw and onerror option but there is no luck

    Please help me to do this task.

    Thanks

    Saturday, July 06, 2013 4:46 AM
    |

Answers