Hi Folks,

I was hoping if anyone of you might be able to help me. I have got SQL Server 2000 with SP3 and I have scheduled a DTS job to import Excel spreadsheet to the database twice per day as soon as the spreadsheet is updated. Funny enough when the data is imported to the database all the columns are OK apart from the PK currently the ID is 6782 when the import is done is supposed to start from 6783 but it starts from 9592 to 9782, then I have to manually delete it from 9592 downwards, then update stats on the table and start all over once again. I have done this over 12 times but am unable to crack the problem and I would be very glad if someone could help me. Early on the error message I got was PK couldn’t be NULL, which I found very hard to understand because the column was not NULL. I look forward to hearing from you all.

Thanks.


CarlWalden

__________________
CarlWalden

If an identity column number is used it cannot be re-used, even if the record is deleted without manual intervention. Are you sure that no records were inserted and then removed, even via a transaction that was rolled back?
Perhaps you could create a new table of identical structure except without the identity, import your old data and then set the identity seed etc?

--

Joe