Hi All,
I have problems with DTS data from Oracle tables that have compound primary key members to SQL Server. DTS prompts "cannot insert duplicate key ..." error on these tables.
For example, the primary key in a table consists 3 key members and I found that, as a compound primary key, the key values are unique, though duplicate values exist in a given single column. I was able to reset the primary key in EM and DTS data into the table, but I am unable to apply the pk constraint afterwards. Could someone advise me why and how to resolve this issue?
Thank you very much for help!
Yichang