Before inserting IDENTITY values in SQLServer you have to turn on IDENTITY_INSERT as here:
SET IDENTITY_INSERT [foo_table] ON INSERT INTO foo_table (...) VALUES (...) ... SET IDENTITY_INSERT [foo_table] OFF