Using "Identity Increment" during a DTS Import?

• jen1franne

  Old Hand

  Points: 333

  More actions

  January 6, 2005 at 5:47 pm

  #163479

  Am very new to SQL Server, just 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!

• babuganesh2000

  Hall of Fame

  Points: 3123

  More actions

  January 7, 2005 at 11:46 am

  #536498

  Zap across the data from the temporary file to a temporary table.

  From, the temporary table zap across the data to the destination table by creating transformation.

  don't create a transformation for that particular column. Associate all other columns with respect to the temporary table.

  I hope it holds good.