Printable View
I continue to get the the following error when importing a CVS file into SqlServer2000:
"cannot insert duplicate key row in object 'table1" with unique index 'table1_ndx'.
I have looked at the records and there are no duplicates. No matter how many rows I test, I continue to get this error after the last row. Is the problem an EOF indicator? Can anyone tell me what the EOF for a CVS is? I would really appreciate it. I have tried everything I know.
Refer what column participate in your unique index. It may be a composite column.
It is not the row that is duplicate, it is the unique key. Easy way to check this is open the CSV file in Excel and order by columns in table1_ndx index and see if there are any dupicates in those columns.
'workorderid_ndx'. It can be sequentially generated but I am entering it. It is an interger
If it's identity column, have to set indentity_insert on to enter value manually.