<div>
determine which foreign key you are conflicting with and either disable it or conform.
</div>


determine which foreign key you are conflicting with and either disable it or conform.

<div>
How would I create a VIEW to filter it out? &nbsp; I think your right on the EOF character, but it might just be easier to delete the row and then manually add it back in. &nbsp;I am only using 2 columns after all. &nbsp;What do you think?
</div>


How would I create a VIEW to filter it out?   I think your right on the EOF character, but it might just be easier to delete the row and then manually add it back in.  I am only using 2 columns after all.  What do you think?

<div>
&gt;&gt;How would I create a VIEW to filter it out? &nbsp;&lt;&lt;<br />
Post the structure of the table.<br />
<br />
&gt;&gt;&nbsp;but it might just be easier to delete the row &lt;&lt;<br />
I agree.<br />
<br />

</div>


>>How would I create a VIEW to filter it out?  <<
Post the structure of the table.

>> but it might just be easier to delete the row <<
I agree.



<div>
<div class="content wysiwyg-content">
I am trying to copy 2 fields from a table into a different table in the same database. &nbsp;Using the DTS I match up the columns and proceed with the copy. &nbsp;It throws an error &nbsp;(INSERT statement conflicted with COLUMN FOREIGN KEY constraint 'XXXXX'....&quot; &nbsp;The error in on the on the very last line in the column. &nbsp;I have tried importing from Excel as well...Same conflict... How do I force it to copy this information over???<br />
<br />
<br />
Thankyou<br />
Robert Zordel<br />
Dataentity, LLC
</div>
</div>


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???


Thankyou
Robert Zordel
Dataentity, LLC

DTS Error...COLUMN FOREIGN KEY constraint...Excel to SQL or SQL to SQL

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.