function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion

How to prevent partial update/ insert while using dataloader

When we inserted records using dataloader, one record got validation error and failed. The rest of them are inserted succesfully.
But, the changes done by trigger for the entire batch ( including succesfully inserted records) are rolled back. 
I guess it is how it works. Using batch size as 1 might prevent this issue but will have performance issues.
Could someone please answer my below queries.
I read some where Dataloader uses DATABASE.UPDATE which allows partial success in DML operation. Is there any setting/ workaround to avoid partial update through dataloader ?
Or is there any better alternative or best practices to avoid these kind of issues ?
Gordon EngelGordon Engel
This post on Stackexchange seems to address your question:
Hi Gordon,
Thanks for the reply.
That post is regarding rollback in BATCH APEX.
What I am looking for is a way to rollback Dataloader operations in case of any error.

Thank you.