Here we have a component tMSSQSP_1 calling a store procedure . This stored procedure returns 10 rows. Now we want to call another stored procedure on these 10 rows one by one.
Now if an error occurs in component tMSSQSP_1 on 5th row then the job gets break which is an issue here. The job should not get break it should continue and process all the 10 rows like the one we could handle in C#.Net using exceptional handling.
Its not like that as if we want sql operation to be fully completed or not?
Our scenario is there could be multiple sql operations required in a sql job and if any of the operation fails then the job should not break.
As in my job there are 10 records fetched from stored procedure now I want to perform some operation on these records using another stored procedure and it worked well for first 5 records and in case some error happens for 6th record then at present job got broken. It should not happen. It should start processing from 7th records onwards.
Also we should be able to log record got failed it would be helpful for our investigation.
Your Stored Proc component will cause the job to end on an error. You need to not use the tMSSqlSP component. If you are familiar with how to call your Stored Procedure using SQL, maybe you can use the tMSSqlRow component (https://help.talend.com/reader/9q55KsfASqX0qY4GVhEDNQ/CN_kA~X9QCVwHfTEqqacZA). This component allows you to error without ending the job.
