Importing Data from Tbl to Tbl

[JVZ]

I need some help importing data from Tbl A to Tbl B, the problem is that Tbl A has 780,000 records, so if I do just do a insert statement I'm running into Locking problems. I tried using a DTS...however I get the following error saying that my RecordID can not be null. Here is a layout of the tables:

TempTbl:
------------
PortNumber, smallint
CycleNumber, varchar(10)
SeqNumber, varchar(10)
FirstError, varchar(10)
SecondError, varchar(10)
ThirdError, varchar(10)
ForthError, varchar(10)
FifthError, varchar(10)
EmiRecord, varchar(210)

ErrorTbl:
------------
RecordNumber, Int(AutoIncrement)
CycleNumber, varchar(10)
SeqNumber, varchar(10)
FirstError, varchar(10)
SecondError, varchar(10)
ThirdError, varchar(10)
ForthError, varchar(10)
FifthError, varchar(10)
EmiRecord, varchar(210)


What I need help with is, coming up with a way to import the records from TempTbl and inserting them into ErrorTbl.

Thanks in advance for you help!