DTS import with identity seed column

• hrodberaht

  SSC-Addicted

  Points: 428

  More actions

  May 28, 2004 at 3:01 am

  #160954

  Hi

  Im tying to import data from a text file to a table. This table has an identity column ([Line Number]), with an identity seed of 1. I have instructed the DTS wizard to 'Ignore' this column, causing an error thats states that NULL values aren't allowed for this column.

  I know I can import this into a new table that does not have a [line number] column, and then do a simple 'insert into', not specifying the [line number] column, into existing table, but I would like to do this directly.

  Any ideas?

  
  Robert

• Greg Charles

  SSC-Forever

  Points: 45403

  More actions

  May 28, 2004 at 9:02 am

  #508226

  Did you have "Enable Identity Insert" enabled?  If so, uncheck it on the "Column Mappings" tab of the wizard.

  Greg

  Greg