Error Handling to send error row in another table


  • 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.


    Saturday, July 06, 2013 4:46 AM