Identity column import

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 Integration Services » Identity column import

Identity column import

Rate Topic

Display Mode

Topic Options

Author

Message

rhythm.varshney

Posted Tuesday, January 29, 2013 11:35 PM

SSC Journeyman

Group: General Forum Members
Last Login: Thursday, March 21, 2013 2:14 AM
Points: 77, Visits: 184

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 ?

Post #1413462

Phil Parkin

Posted Thursday, January 31, 2013 2:40 AM

SSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 10:13 AM
Points: 4,227, Visits: 9,460

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.

____________________________________________________________________________________________

Help us to help you. For better, quicker and more focused answers to your questions, consider following the advice in this link:

http://www.sqlservercentral.com/articles/Best+Practices/61537/

If you are asking for help and your post does not contain a question, you should expect responses which do not contain any answers. Put a question mark in there somewhere - it's not rocket science.

Post #1413934

« Prev Topic | Next Topic »

Permissions