Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Identity column import Expand / Collapse
Author
Message
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


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 2:15 AM
Points: 5,317, Visits: 12,354
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.

It is better to keep your mouth shut and appear stupid than to open it and remove all doubt. (Mark Twain)
Post #1413934
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse