ETL and Data Integration tools - Modern ETL software for everyone

Hi,

I am testing Visual Importer Pro on behalf of a customer. When I try to run a import from access to MS SQL 2005 with Add and Update transformation, i get an Primary key violation: "Cannot insert duplicate key in object... It seems that your software is trying to do a insert rather than a update. I am using ODBC connection. An import without any updated fields works like a charm.

Best regards

Andreas

Hello

May be update key you specified is different from table primary key?

If it is not the case

Can you email us
your table creation script
example of source data
Screenshot of mapping
Import script

Mike