Update:Error on Update Failure - "No Key available for Update"

[tfranz]

I am trying to update a column in a table using the Output Data tool and keep getting the message "No Key available for Update"

My table has a Primary Key defined as a composite key, made up of 4 columns. In the Key for Update section I have listed all the columns and in the order they preside in the Primary Key. I am only wanting to update one value in the table.  

I am not even sure if I am using the tool correctly because the examples for the Output tool do not mention Update. 

My question is should I be able to Update a single-column in a table where the PK of the table is a composite key? If the answer is yes, can anyone point out what I am doing incorrectly?

The pictures of my workflow are attached.

[TimN · Accepted solution]

You need to provide the Composite PK column mapping in the Custom mapping you pictured.  

[tfranz]

The columns in the composite primary key are listed (and in the correct order) in that section.  That doesn't solve this issue.

[TimN]

Hi,

Based on the Word doc you provided, you have not mapped the columns that make up the composite key in the Custom mapping.

[tfranz]

Thank you. I misunderstood the earlier post. Didn't realize the key had to be in the Custom Mapping as well. I thought it would just need the column I was updating. Thanks again.

[TimN]

Hi,

Please mark the answer as the solution if this solved the problem.

Thanks.