Update and Delete error in SSIS

Update and Delete error in SSIS

Postby 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
iznogood
 
Posts: 3
Joined: Wed 19 Mar 2014 12:39

Re: Update and Delete error in SSIS

Postby Shalex » Tue 25 Mar 2014 10:09

Thank you for your report. We are investigating the issue.
Shalex
Devart Team
 
Posts: 7460
Joined: Thu 14 Aug 2008 12:44

Re: Update and Delete error in SSIS

Postby 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).
Shalex
Devart Team
 
Posts: 7460
Joined: Thu 14 Aug 2008 12:44


Return to dotConnect for MySQL