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

[mra802003]

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

[Anonymous · Accepted solution]

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

[mra802003]

Thanks rhall.

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