I have a table called Employees(RowID,EmpNo, Lastname, Firstname). Here RowID is autogenerated by the system. It is the primary key and DOES NOT allow NULL values. I CANNOT change the table structure.
I am trying to import data from a text file through the Import Data Wizard in the Enterprise Manager. The textfile has all the above columns(EXCEPT the RowID as it should be autogenerated).
At the end of the import, the system gives me the error "Column RowID - Integrity violation attempt to insert NULL values". I have tried to disable/enable the "Enable identity insert option" in the import wizard but it does not work.
Can you please tell me what could be the solution for this error?
April 5, 2005 7:18 PM
April 8, 2005 11:12 AM