I want to create a job through which we want to handle the success and failures of the steps. Can some one please tell me how this can be done. Some tutorial or video for this could be of very much help.
Here is an example for your reference
Suppose we are fetching the results from stored procedure using tMSSQLSP component. How ever stored procedure got failed in that case we need to send email to the administrator informing him about the failure. And in case of success of stored procedure we want results fetched from tMSSQLSP component to be inserted to some data base table.
Thanks for the answer.
When an exception occurs I want to log that error message in my data base table. for that I am using
tLogCatcher_1 > tMSSQLSP_2
Through tMSSQLSP_2 i am calling a stored procedure which will log the error message in to the data base table. But I am not getting the way to fetch the error message which caused flow to come to tLogCatcher_1.
Can some one please help me on this?
I have solved this issue. I got error message through tLogCatcher schema and got that error message in tMSSQLSP.
Thanks for helping.