January 6, 2005 at 7:11 pm
Am learning how to do an import using DTS wizard. My table's 1st column is
like a Sequence Number/PK (called Identity in MS SQL Lingo?).
Defined to start at seed 1, increment by 1.
I'm importing data for first time into this table from a
comma-delimited file (which populates all other columns except for 1st column). How do I make DTS Wizard generate the sequence number for that first column during the Import ?
Thanks!
January 6, 2005 at 7:54 pm
You can remap columns by clicking "Transform" but the import failed when I tried it because of the identify field.
Create a work table that has all of the fields except for the identify field. Use DTS to import the data into that table. Then, using a SQL statement, insert the data from the work table into the production table. You'll have to specify all of the columns except leave the identity field out.
Aunt Kathi Data Platform MVP
Author of Expert T-SQL Window Functions
Simple-Talk Editor
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply