I did something like this before, but you have to make sure and insert an identity row in your tempe table and use that as your UniqueID:

declare @counter int

declare...

Maybe use a front-end to import all the data?  Or do you need to do it on a Bulk Insert?

select * from Table1 Insert into Table2 where 1=2

OR

CREATE TABLE student2 SELECT * FROM student WHERE 1=2