SQL Server 2000 insert primary key in import

[Hoardling via AccessMonster.com]

I have a table that has a primary key. What I am doing is importing data
from another table into this table. The data being imported doesn't have a
primary key field. My problem is SQL Server 2000 isn't auto populating the
primary key field. Identity is set and on the DTS import I am saying Enable
Identity. So how can I import data and get the primary key field to populate?
If not on the import part how can I get it to populate the primary key field
after the import?

 

[Hoardling via AccessMonster.com]

Ok, I figured it out. I had uncheck Enable Identity and set my Source for
primary key to ignore and leave destination as the primary key. Worked fine.