[resolved] tMysqlInput ignore error

[Anonymous]

hi,
have a job that has to iterate a set of records and feed it to tMysqlInput component. I want to set it up in a way that even if tMysqlInput encounters an error, it will proceed to the next iteration.
tMysqlInput_1 -> IterateEachRecord ->tMysqlInput_2 -> tMysqOutput_1
Please help me on how to do this.

thank you so much!
-Chim

[Anonymous · Accepted solution]

You need to design the jobs like this:
main job:
tmysqlinput1--iterate--tRunJob

tRunJob: call the child job, and pass the current record to child job, refer to this KB article to learn how to pass data from main job to child job with context variables, uncheck the 'die on error' option to make the main job continue to execute even though the child encounters an error.

child job:
tMysqlInput_2 -> tMysqOutput_1


Regards
Shong

[Anonymous]

great - thanks!