Inserting data from one table to another

• Gary Morey

  Newbie

  Points: 1

  More actions

  February 2, 2007 at 2:26 pm

  #175895

  When using Data Transformation Services to export data from a table in one database to a table in another database, how do I keep the identity column values the same in the target database table as they are in the source database table?

• dba4eva

  SSC-Addicted

  Points: 467

  More actions

  February 2, 2007 at 3:22 pm

  #687573

  you can specify IDENTITY INSERT ON for the target table.