Is this going to be a one-time job?

Or will you be running this scheduled (daily, weekly...) as new files come in?

So you receive MYFILE01012009.txt, then MYFILE01022009.txt... each day?

Will all the...

If you just want to copy the data (or selected data) and keep the identity values as is, there is a flag you can set so that you can enter...

INSERT INTO Employee (Name, CardNo)

SELECT T.Name, T.CardNo

FROM Emp_Detail T

WHERE NOT EXISTS (SELECT TOP 1 1

FROM Stuff_Detail I

...

It's just missing one thing - a disclaimer: "Unless you're a manager." At one job, had to teach all these to the self proclaimed "DBA Specialist." And then...