CODEWITHSUNDEEP
ssis
WingMan20-10
WingMan20-10

Reputation: 3734

SSIS export data to database with similar scheme on different server

I have to similar databases on different instances. I needed to export All data in All tables from One instance to another.

The problem i am having is i need to keep all the Unique Id's from the columns that i have the identity insert on. Example:

Value of (Instance1-->Table1-->Id(Identity Column)) needs to be the same as: Value of (Instance2-->Table1-->Id(Identity Column)).

Upvotes: 0

Views: 89

Answers (1)

Pete Carter
Pete Carter

Reputation: 2731

On your OLEDB destination, there is an option called KeepIdentity Select this option. This is the equilavent of SET IDENTITY_INSERT ON

Upvotes: 3

Related Questions