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
Update and Delete error in SSIS
Re: Update and Delete error in SSIS
Thank you for your report. We are investigating the issue.
Re: Update and Delete error in SSIS
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).
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).