ETL and Data Integration tools - Modern ETL software for everyone

Dear Support,

I am attempting to import data into a SQL database of customer equipment to test your visual importer. I do not know how to correctly import into a table with two fields which comprise the primary key. In the example below, the customer and address_id combine to make the primary key. A Customer may have more than one record if they have more than one location but the combination of customer and address_id is unique. When I import, I get an error -

bcp_done Failed: 23000 [Microsoft][ODBC SQL Server Driver][SQL Server]Violation of PRIMARY KEY constraint 'PK__SVC_ADDRESS__173876EA'. Cannot insert duplicate key in object 'SVC_ADDRESS'. 01000 [Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated.

Can you help me understand how to correct this error. Love your product so far! Thanks.

M.Todd

Perhaps the problem is not with the source data but with the target?

You have duplicates in target database?

Try using "add new update existing records transformation"

John