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

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.

Update Error on Update Failure-No key available for Update.docx

Error Message

Output

Accepted answers

TimN

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

All comments

TimN

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.

CustomMap.bmp

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.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703