Hi I have a question on how to catch a exception which is thrown by .NET component in Orchestration.
My Scenerio is From Orchestration I am calling a .NET component or method with a parameter and this method inserts data into SQL tables. So my question is if the SQl server is down or the method couldnt insert data into SQL it has to throw an exception and that exception I need to catch in the biztalk orchestration and send it to the SMTP port.
so How do I catch exception in orchestration which is thrown by .NET component.
Please give detail information about how to implement exception handling for that method and how to catch that exception in orchestration.
Thanks