Post reply

Identity column import

  • 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 ?

  • 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.

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply