Devart MySql Destination Duplicates

Discussion of issues, suggestions and bugs of Devart SSIS Data Flow Components, our product line for building SSIS-based ETL solutions, performing data access to popular cloud applications and databases.
Post Reply
FunnyName123
Posts: 11
Joined: Thu 01 Jun 2017 12:54

Devart MySql Destination Duplicates

Post by 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

Pinturiccio
Devart Team
Posts: 2420
Joined: Wed 02 Nov 2011 09:44

Re: Devart MySql Destination Duplicates

Post by 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.

FunnyName123
Posts: 11
Joined: Thu 01 Jun 2017 12:54

Re: Devart MySql Destination Duplicates

Post by 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 :)

Post Reply