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!