Error message

• Katarina

  Newbie

  Points: 1

  More actions

  September 28, 2004 at 2:53 am

  #89438

  Hi all,

   

  I'm a total newbie on SQL and can't really anything about it.

  I have a database which is transfeering data between our business system and a SQL server. I recieve an error saying:

  Import Wizard

  Database Major error [User]: <n/a>

  Description: Microsoft OLE DB Provider for SQL Server: Insert into 'relCaesarUserCustomer' requires a matching key in 'Code'.

  Is anyone able to tell me how to correct this or give me a hint on where to look to be able to see what this error comes from.

  Thanks so very much in advance!

  Regards

  Katarina

   

• jordanac

  Hall of Fame

  Points: 3653

  More actions

  September 28, 2004 at 4:20 am

  #524596

  What version of SQL Server are you using? (Not sure about this error message)

  Here is a rough guess.

  This sounds like a referential integrity violation. Does this table have an index and is there a foreign and primary key?

    

  
  Andy.