TSalesforceOutput "Reject" not working

TSalesforceOutput "Reject" not working

Hope someone can help me!
I have added a screenshot below of the job I have set up. The file has 88 rows in it (as this is test data but will be uploading much more than that when it comes to live data).
If I set up the batch size to 1, it captures all the errors and puts them into the "Redbox_exception__c" table, but if I have the batch size set to 200, then it just ignores the error and says all was inserted corrected (even though I only have 87 records in the Account table).


These are my settings, which do not save the error in the system, but if I change commit level to 1, it does save it.

Surely for me to capture the rejected rows I shouldnt have to be inserting 1 at a time!
Thank you!
One Star

Re: TSalesforceOutput "Reject" not working

What if you uncheck Extend Insert?

Re: TSalesforceOutput "Reject" not working

What if you uncheck Extend Insert?

TRF
If I do that, it removes the ability to set the batch size and just inserts 1 at a time.