Hi,
in Talend 5.2, how can I capture the rejected rows in tMSSqlOutput.
Component settings:
- Action on table: none
- Action on data: insert
- Die on error: unchecked
Thanks
Antonio del Olmo
Hi
Please check that the 'Use batch size' option is selected or not, this option can not be used with reject link together, so this option should be unchecked if you want to use reject link.
Shong
Hi,
What is your work flow? I think you can add a tMap component in the middle of row link and set a rejected row in Map Editor
Please see the related article with scenario
Mapping the Output setting and
Connection types. Could you give us more description about your job so that we can design a proper work flow for you.
Best regards
Sabrina
Yes, I have a job of Talend 3.1. In this version the tMsSqlOutput permit the rejected output, but in Talend 5.2, this link is not valid. I insert in the output all rows, but when a row launch an error when try to insert, I capture this row and insert it in a log table. Can you understand me? Thanks in advance
Hi, I think you are looking for "ErrorReject". This row link connects a tMap component to an output component. This link is enabled when you clear the Die on error check box in the tMap editor and it gathers data that could not be processed (wrong type, undefined null value, unparseable dates, etc.). Best regards Sabrina
Is an option, but this ErrorReject tMap output not capture the error of rows that can´t insert into destiny table. Por example, a reject row for index violation. In Talend 3.1.3, this option are available, how can i reproduce this option in talend 5.2?
Hi
Please check that the 'Use batch size' option is selected or not, this option can not be used with reject link together, so this option should be unchecked if you want to use reject link.
Shong
