topic Re: Is there a way to capture error rows in MSSQLOutput without unchecking "Use Batch Size"? in Talend Studio

Is there a way to capture error rows in MSSQLOutput without unchecking "Use Batch Size"?

mra802003 — Thu, 16 Jan 2020 16:59:10 GMT

Hi,

It seems we cannot capture error rows (reject link) generated due to database errors without disabling "Use Batch Size". We see a drastic performance impact in thorough put when batch size is disabled.

Is there a way we can have the benefit of both worlds - performance and capture error rows?

Thanks,

Manish

Re: Is there a way to capture error rows in MSSQLOutput without unchecking "Use Batch Size"?

Anonymous — Sun, 02 Feb 2020 17:49:25 GMT

I'm afraid this is not possible. You are sacrificing granularity in logging for performance.

Re: Is there a way to capture error rows in MSSQLOutput without unchecking "Use Batch Size"?

mra802003 — Thu, 06 Feb 2020 20:47:03 GMT

Thanks rhall.

I designed the job to capture missing error rows from target in a separate flow.