error message on DTS

Dev Shed Forums Sponsor:

November 14th, 2004, 06:41 AM

juecal

Registered User

Join Date: Apr 2004

Location: California

Posts: 27

Time spent in forums: < 1 sec
Reputation Power: 0

error message on DTS

does anyone know what this error means?

Quote:

Error Description : The task reported failure on execution.
The statement has been terminated.
INSERT statement conflicted with COLUMN FOREIGN KEY constraint 'FK_saleItem_itemID_1DE57479'. The conflict occured in database 'petstore',
table 'merchandise', column 'itemID'.

if so...any suggestions/ideas on how it can be corrected?

November 14th, 2004, 07:27 AM

r937

SQL Consultant

Join Date: Feb 2003

Location: Toronto Canada

Posts: 17,653

Time spent in forums: 1 Month 3 Weeks 6 Days 12 h 42 m 2 sec
Reputation Power: 981

it means you tried to insert a value into a foreign key field that doesn't exist in the primary key column that it references

it can be corrected by changing the value to one that does exist in the primary key column

__________________
r937.com | rudy.ca

Viewing: Dev Shed Forums > Databases > MS SQL Development > error message on DTS

« Previous Thread | Next Thread »

Thread Tools	Search this Thread
Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off

View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox

Forum Jump