This error likely means the destination table you are trying to update doesn’t have a primary key, which is making the job fail.

In order to fix this issue, you will have to do two things:

     1. Go to your connection manager and AllowUpdatesWithoutKey=True in the Other connection property.

     2. Then, go to your destination component “Properties” and for “Filter Columns”, please specify the column the component should use in the WHERE clause for running the updates. On the example below, I want to update based on the “acct_id” field of my table:

After doing this, the job should run successfully.