SQL Server 2000, cope table from DB-A to DB-B, while skipping primary key duplicates

• code123red

  Newbie

  Points: 9

  More actions

  November 5, 2013 at 5:17 pm

  #146432

  I have two databases, and I tried copying/combining data from table a to table b but it fails each time due to the primary key error.

  Select Distinct does not work, "insert into" gives me " does not support all the interfaces/methods required by dts"

  Thank you.