Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Identity column import Expand / Collapse
Posted Tuesday, January 29, 2013 11:35 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Thursday, September 19, 2013 4:30 AM
Points: 78, Visits: 195
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
Posted Thursday, January 31, 2013 2:40 AM



Group: General Forum Members
Last Login: Today @ 11:26 AM
Points: 7,982, Visits: 19,121
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.

When you ask a question (and please do ask a question: "My T-SQL does not work" just doesn't cut it), please provide enough information for us to understand its context.

If your posting includes some T-SQL code, please surround the code with IFCode formatting tags. It helps readability a lot.
Post #1413934
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse