Import Failed

• markbruso

  Newbie

  Points: 5

  More actions

  March 20, 2003 at 11:45 am

  #159639

  Trying to execute DTS Import Wizard. Want to copy one table including data and indexes from one SQL2000 db to another. Getting the error "ODBC SQL State: 42501 There is already an object named 'DF _Temporary_ItemO_38B96646' in the database...Could not create constrant"

  Could anyone help me with this?

• mhweiss

  SSCarpal Tunnel

  Points: 4284

  More actions

  March 20, 2003 at 11:53 am

  #451608

  For some reason, SQL Server believes there is a default constraint in the target database with the same name as one it is trying to copy over from the original...at least that is my guess. Can you try running in the target database the following:

  ALTER TABLE [dbo].[mytablename] DROP CONSTRAINT [DF _Temporary_ItemO_38B96646]

  You may have to get to this object by using the ObjectID() function...

  hth,

  Michael

  Michael Weiss

  
  Michael Weiss

• philcart

  SSC-Forever

  Points: 47797

  More actions

  March 20, 2003 at 6:19 pm

  #451644

  The Wizard usually includes a create table step. If the table already exists, you should remove the create table task from the package.

  Hope this helps

  Phill Carter

  --------------------

  Colt 45 - the original point and click interface

  --------------------
  Colt 45 - the original point and click interface