SQL Server 2000 insert primary key in import

  • Thread starter Thread starter Hoardling via AccessMonster.com
  • Start date Start date
H

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?
 
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.
 
Back
Top