Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004

    Question Unanswered: Column Foreign Key constraint 'EOR_ITE_REF_EOR'

    I am importing data from a flat, comma delimited text file. It appears to properly import all the records and then on the last record it give me the error

    INSERT statement conflicted with COLUMN FOREIGN KEY constraint for 'EOR_ITE_REF_EOR'.

    Then it goes on to tell me the database, table and column in which the problem occured which is the first column in the table. It looks like it doesn't like the end of the file for some reason (EOR, end of record?) so I tried deleting the last record from the file and it still does it. I do have a file that I have imported that worked so I tried copying the last record of that file and pasting it into the last record of the file I wanted but that did not work either. The ends of file that works and the file that doesn't work look the same and I can find nothing on 'EOR_ITE_REF_EOR'. Any help would be appreciated.

  2. #2
    Join Date
    Feb 2004

    Re: Column Foreign Key constraint 'EOR_ITE_REF_EOR'

    I would think that the 'EOR_ITE_REF_EOR' is the name of the constraint, not an indication of the end of the input file.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts