DTS-Cannot Insert Duplicate Key Row - EOF?

[rmtiptoes]

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.

[MAK]

Refer what column participate in your unique index. It may be a composite column.

[skhanal]

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.

[rmtiptoes]

'workorderid_ndx'. It can be sequentially generated but I am entering it. It is an interger

[rmiao]

If it's identity column, have to set indentity_insert on to enter value manually.