DTS Error...COLUMN FOREIGN KEY constraint...Excel to SQL or SQL to SQL
Posted on 2005-03-28
I am trying to copy 2 fields from a table into a different table in the same database. Using the DTS I match up the columns and proceed with the copy. It throws an error (INSERT statement conflicted with COLUMN FOREIGN KEY constraint 'XXXXX'...." The error in on the on the very last line in the column. I have tried importing from Excel as well...Same conflict... How do I force it to copy this information over???