Import Wizard failing to insert with Identity Column

• jamie_collins

  Ten Centuries

  Points: 1192

  More actions

  August 6, 2013 at 10:16 am

  #395251

  I am trying to import from one table into another with the import/export wizard...

  The source table has 17 columns , one of them an identity.

  I am using a query to insert into the target table.

  I exclude the id column from my query and enable identity insert but get the 'Cannot insert null into id column'.

  The select on the source returns 189 rows all of which have a value for the id column...

  Not sure what I am doing wrong.

  Thanks

• Ed Wagner

  SSC Guru

  Points: 287026

  More actions

  August 6, 2013 at 10:20 am

  #1639015

  If you enable identity insert in the GUI, then you have to include and map the identity field.

  If you have it unchecked, you should exclude the field (set to ignore) in the list of fields to import.

  Tally Tables - Performance Personified
  String Splitting with True Performance
  Best practices on how to ask questions