Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik and ServiceNow Partner to Bring Trusted Enterprise Context into AI-Powered Workflows. Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Croix
Creator
Creator

tMSSqlOuput Has No Reject Row Output

Hi, 

 

My tMSSqlOutput in my Talend Big Data Studio 6.2.1 doesn't have the reject row ability. Does anyone know how to enable it?

 

In the documentation on this page https://help.talend.com/?_ga=2.40966626.1955089195.1496179548-1742472758.1493743590#/reader/wDRBNUux...

it says 

"Die on Error: This check box is selected by default. Clear the check box to skip the row on error and complete the process for error-free rows. If needed, you can retrieve the rows on error via a Row > Rejects link."

I unchecked the die on error box and there still isn't any "rejects" link on the row menu item. 

Thanks,

Croix

Labels (3)
1 Solution

Accepted Solutions
Anonymous
Not applicable

Soory I had read for MysqlOutput.

For MsSQlOutput, in Advanced Setting, uncheck "Use batch size"

View solution in original post

4 Replies
Anonymous
Not applicable

Hi seewaage ,

uncheck in Advanced Setting "Extend insert"
Croix
Creator
Creator
Author

Hi pierre,
Thanks for the response. My tMSSqlOutput advanced settings does not have a checkbox called "extend insert". The basic settings doesn't have this box either.
Ideas anyone? I'm not sure why my Talend Studio 6.2 doesn't have these boxes.
Thanks,
Croix
Anonymous
Not applicable

Soory I had read for MysqlOutput.

For MsSQlOutput, in Advanced Setting, uncheck "Use batch size"
Croix
Creator
Creator
Author

Thanks pierre!

I unchecked "use batch size" like you said and the reject row popped up! 

I appreciate your help with this.

Croix