Update and Delete error in SSIS

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for MySQL
Post Reply
iznogood
Posts: 3
Joined: Wed 19 Mar 2014 12:39

Update and Delete error in SSIS

Post by iznogood » Wed 19 Mar 2014 12:54

Hi

I'm using the Devart MySQL Destination component i SSIS 2012, and have problems with the 'action' update and delete.

Update problem:
My table have a primary key on two attributes, when I trace the sql om mySQL it seems like it only uses the first attribut in the update and the update fails.

Delete problem:
My table have a primary key on two attributes, when I trace the sql om mySQL it seems like it only uses the first attribut in the delete and the attribute is NULL, the delete don't fail, but no recorsd is deleted.

I'm using dotConnect for Mysql Professionel 8.2.103

Regards
Jesper

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Re: Update and Delete error in SSIS

Post by Shalex » Tue 25 Mar 2014 10:09

Thank you for your report. We are investigating the issue.

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Re: Update and Delete error in SSIS

Post by Shalex » Fri 25 Apr 2014 10:05

The bug with applying the Update and Delete actions in the SSIS DataFlow Destination component for tables with composite primary key is fixed in the new 8.3.146 build of dotConnect for MySQL: http://forums.devart.com/viewtopic.php?f=2&t=29437.

It can be downloaded from http://www.devart.com/dotconnect/mysql/download.html (trial version) or from Registered Users' Area (for users with active subscription only).

Post Reply