Identity column import

• rhythm.varshney

  Ten Centuries

  Points: 1138

  More actions

  January 29, 2013 at 11:35 pm

  #269845

  I need to import data of a table from prod environment to my dev DB.

  This table is having one identity column and also there are gaps in between as some records have been deleted from prod.

  Now I want all columns value including identity column to dev DB same as Prod DB table.

  How can i achieve it using SSIS ?

• Phil Parkin

  SSC Guru

  Points: 246963

  More actions

  January 31, 2013 at 2:40 am

  #1582829

  Two options:

  1) Remove the IDENTITY definition on the destination table and insert as usual.

  2) Set identity insert on during the import and insert as usual.

  The absence of evidence is not evidence of absence
  - Martin Rees
  The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
  - Phil Parkin