Six Stars

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

  • Data Integration
1 ACCEPTED SOLUTION

Accepted Solutions
Four Stars

Re: tMSSqlOuput Has No Reject Row Output

Soory I had read for MysqlOutput.

For MsSQlOutput, in Advanced Setting, uncheck "Use batch size"
4 REPLIES
Four Stars

Re: tMSSqlOuput Has No Reject Row Output

Hi seewaage ,

uncheck in Advanced Setting "Extend insert"
Six Stars

Re: tMSSqlOuput Has No Reject Row Output

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
Four Stars

Re: tMSSqlOuput Has No Reject Row Output

Soory I had read for MysqlOutput.

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

Re: tMSSqlOuput Has No Reject Row Output

Thanks pierre!

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

I appreciate your help with this.

Croix