Update and Delete error in SSIS
Posted: 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
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