Hi experts,

Hope someone can guide me on this problem. I'm trying to import mytext1.txt
into
myDB table mytable1. During the import process I received this message:-

Copy data from mytext to myDB.dbo.mytable1 step

Error at Destination for Row 446109. Errors encountered so far in this task: 1
The statement has been terminated.
INSERT statement conflicted with COLUMN FOREIGN KEY constraint 'FK_ACN'.
The conflict occured in database myDB, table 'MYOTHERTABLE', column 'ACN'

TQ.

Hi
The reason for this is due to a Referential Integrity failure.

You might be trying to enter a value into the Foreign Key table, with out
the corresponding entry in the Master Table.

Please enter a value in the Master Table and try again.


--
best Regards,
Chandra
http://chanduas.blogspot.com/
http://groups.msn.com/SQLResource/
---------------------------------------



"GW" wrote:

The error message says it all really.

You have inserted a row into a child table with a foreign key reference
to a parent table with primary key for which there is no matching
primary key value for the foreign key value inserted.

You should insert the parent table first OR you should import the text
file to a staging table and then match the intended foreign key values
with the existing Primary Key values

Allan



"GW" <GW (AT) discussions (DOT) microsoft.com> wrote