The UPDATE statement conflicted with the FOREIGN KEY constraint

One Star

The UPDATE statement conflicted with the FOREIGN KEY constraint

Hello,
when I start my Job i got this message on my console.
"The UPDATE statement conflicted with the FOREIGN KEY constraint "FK_BUSINESSES_CLIENTS". The conflict occurred in database "my_database", table "dbo.table", column 'Name_id'.
The INSERT statement conflicted with the FOREIGN KEY constraint "FK_BUSINESSES_CLIENTS". The conflict occurred in database "my_database", table "dbo.table", column 'Name_ID'."
When I change the db of my input its work perfectly.
Thanks for your help.
Moderator

Re: The UPDATE statement conflicted with the FOREIGN KEY constraint

Hi,
What's your job design? Please show us your job design screenshots so that we can get your current situation more precisely.
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: The UPDATE statement conflicted with the FOREIGN KEY constraint

here
One Star

Re: The UPDATE statement conflicted with the FOREIGN KEY constraint

Dont know why my photo and my link didnt work:
http :// imgur.com / 774gaIf
Moderator

Re: The UPDATE statement conflicted with the FOREIGN KEY constraint

Hi proutprout,
We cannot see your image. Could you please register and log in as a Community member to see if you can upload your screenshots?

Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: The UPDATE statement conflicted with the FOREIGN KEY constraint