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.
Arthur My Blog
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.
Would you like to participate?