From Thursday, July, 9, 3:00 PM Pacific,
our Community site will be in
read-only mode
through Sunday, July 12th.
Thank you for your patience.

tMSSqlOuput Has No Reject Row Output

Highlighted
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


Accepted Solutions
Highlighted
Six Stars

Re: tMSSqlOuput Has No Reject Row Output

Soory I had read for MysqlOutput.

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

View solution in original post


All Replies
Highlighted
Six Stars

Re: tMSSqlOuput Has No Reject Row Output

Hi seewaage ,

uncheck in Advanced Setting "Extend insert"
Highlighted
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
Highlighted
Six Stars

Re: tMSSqlOuput Has No Reject Row Output

Soory I had read for MysqlOutput.

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

View solution in original post

Highlighted
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

2019 GARTNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog