Devart Forums

I've recently had a few issues with the destination component, specifically duplicates. When the destination is set to "Bulk Insert" it's inserting duplicates into my table, but it doesn't do this to all of the records. So when I change the operation to "Insert", my data goes in fine with zero duplicate records.

Is this a bug? Or am I missing something?

Thanks,
Tom

The "Bulk Insert" operation unites several inserts in one batch. If one of the inserts causes an error, it re-executes inserts one-by-one. Probably the records before the error were inserted successfully, and then the same records are re-inserted. We will investigate this behaviour and notify you about the results.
Please use usual inserts as a workaround for now.

Thanks for the quick reply.

I've updated the operation to "Insert" and it's working fine; albeit a little bit slower