ETL and Data Integration tools - Modern ETL software for everyone

Help me please!!!

How do I import a record set and have the system assign the primary key
based on the next value in the DB?

For instance I have a table:

Products.
Products.id
Products.partnumber
Products.desc

I want to upload a say 100 values of partnumber and desc
1234 FOO
4568 BAR
...


Let's say that the last value in the products. table is
ID : partnumber : desc
45886 : 4589 : FOOBAR

And when the upload/import is set to create new records, I want it to
automatically assign the next primary key value according to what the DB
"tells" it. I will not always have visibility into what the next value of
the key is so I can't include it in the upload without risking duplicate
keys.

How do I set the upload to do what I need?

Thanks!
T.

Hi.

What is your target database?

Mike

Mike

It is MSSQL

T

Todd.

You can use identity field for you primary key

CREATE TABLE dbo.PRODUCTS
(
PRODUCT_ID int NOT NULL IDENTITY (1, 1),
PRODUCT varchar(50) NULL
) ON [PRIMARY]
GO

Mike

Thanks a lot for your help. It turns out that apparently the database is "smart" enough to ignore what I put in the key field and it just assigns it the next appropriate key.

I have no idea what I'm doing by the way... Just playing with live data on a production website!

T