topic Re: tMSSqlOuput Has No Reject Row Output in Talend Studio

tMSSqlOuput Has No Reject Row Output

Croix — Sat, 16 Nov 2024 09:43:00 GMT

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/wDRBNUuxk629sNcI0dNYaA/1zj_Uz5uO~UTXHaCzVK4OQ

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

Re: tMSSqlOuput Has No Reject Row Output

Anonymous — Wed, 31 May 2017 10:59:51 GMT

Hi seewaage ,

uncheck in Advanced Setting "Extend insert"

Re: tMSSqlOuput Has No Reject Row Output

Croix — Wed, 31 May 2017 16:13:08 GMT

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

Re: tMSSqlOuput Has No Reject Row Output

Anonymous — Wed, 31 May 2017 16:17:04 GMT

Soory I had read for MysqlOutput.

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

Re: tMSSqlOuput Has No Reject Row Output

Croix — Wed, 31 May 2017 16:23:45 GMT

Thanks pierre!

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

I appreciate your help with this.

Croix