-- Create tables
-- Parts table. It has an identity column and GUID column.
CREATE TABLE Parts(col1 INT, col2 INT, idCol INT NOT NULL IDENTITY(1,1), guidCol uniqueidentifier);

-- Staging table. It does not have the identity column and the GUID column. 
--The structure of this table should match the data file.
CREATE TABLE PartsStaging(col1 INT, col2 INT);

-- Insert some data into the staging table.
INSERT INTO PartsStaging SELECT 1,10 UNION SELECT 2,11 UNION SELECT 3,12;

-- Script to insert the data from the staging table into the Parts table.
INSERT INTO 
   Parts (col1, col2, guidCol)
SELECT
   col1,
   col2,
   NEWID()
FROM
   PartsStaging;

-- cleanup staging table (or you will need to truncate it it before you do the next import).   
TRUNCATE TABLE PartsStaging;

-- see what you have in the Parts table.
SELECT * FROM Parts

-- Create tables
-- Parts table. It has an identity column and GUID column.
CREATE TABLE Parts(col1 INT, col2 INT, idCol INT NOT NULL , guidCol uniqueidentifier);

-- Staging table. It does not have the identity column and the GUID column. 
--The structure of this table should match the data file.
CREATE TABLE PartsStaging(col1 INT, col2 INT);

-- Insert some data into the staging table.
INSERT INTO PartsStaging SELECT 1,10 UNION SELECT 2,11 UNION SELECT 3,12;

-- add the identity column in the staging table and set the starting id to 
-- whatever you need it to be, for example, 1477
alter table PartsStaging add idCol int not null identity (1477,1);

-- Script to insert the data from the staging table into the Parts table.
INSERT INTO 
   Parts (col1, col2, idCol, guidCol)
SELECT
   col1,
   col2,
   idCol,
   NEWID()
FROM
   PartsStaging; 

-- cleanup staging table (or you will need to truncate it it before you do the next import).   
DROP TABLE PartsStaging;

-- see what you have in the Parts table.
SELECT * FROM Parts