Devart MySql Destination Duplicates

Devart MySql Destination Duplicates

Postby FunnyName123 » Mon 12 Jun 2017 12:07

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
FunnyName123
 
Posts: 11
Joined: Thu 01 Jun 2017 12:54

Re: Devart MySql Destination Duplicates

Postby Pinturiccio » Wed 14 Jun 2017 11:43

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.
Pinturiccio
Devart Team
 
Posts: 2025
Joined: Wed 02 Nov 2011 09:44

Re: Devart MySql Destination Duplicates

Postby FunnyName123 » Mon 19 Jun 2017 14:12

Thanks for the quick reply.

I've updated the operation to "Insert" and it's working fine; albeit a little bit slower :)
FunnyName123
 
Posts: 11
Joined: Thu 01 Jun 2017 12:54


Return to SSIS Data Flow Components