# "The primary key must be specified to update a row" error - SSIS Destination components

**URL:** <https://community.cdata.com/t/the-primary-key-must-be-specified-to-update-a-row-error-ssis-destination-components/1015>\
**Category:** CData Drivers\
**Tags:** question, ssis\
**Created:** [January 31, 2025, 9:45pm UTC](https://community.cdata.com/t/the-primary-key-must-be-specified-to-update-a-row-error-ssis-destination-components/1015 "2025-01-31T21:45:21Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Rodrigo\_de\_Albuquerque](https://avatars.discourse-cdn.com/v4/letter/r/ea666f/32.png) [@Rodrigo\_de\_Albuquerque](https://community.cdata.com/u/Rodrigo_de_Albuquerque)\
**Post date:** [January 31, 2025, 9:45pm UTC](https://community.cdata.com/t/the-primary-key-must-be-specified-to-update-a-row-error-ssis-destination-components/1015/1 "2025-01-31T21:45:21Z")

</div>

When trying to run an update with my CData SSIS Destination components, the job is failing with the following error: “The primary key must be specified to update a row”. What should I do to workaround this problem?

---

<div class="post-metadata">

**Author:** ![Rodrigo\_de\_Albuquerque](https://avatars.discourse-cdn.com/v4/letter/r/ea666f/32.png) [@Rodrigo\_de\_Albuquerque](https://community.cdata.com/u/Rodrigo_de_Albuquerque)\
**Post date:** [January 31, 2025, 9:53pm UTC](https://community.cdata.com/t/the-primary-key-must-be-specified-to-update-a-row-error-ssis-destination-components/1015/2 "2025-01-31T21:53:23Z")

</div>

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&nbsp;AllowUpdatesWithoutKey=True in the Other connection property.

 ![7a073001-f05a-49bd-9d8e-c8929040bfc2.png](https://us1.discourse-cdn.com/cdata/original/2X/0/0dff3b1247e12876e1e7fffd478fe9e78edd0d1c.png)

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:

 ![5b4b50d2-95d3-4be4-8794-3f8ea5941d1e.png](https://us1.discourse-cdn.com/cdata/original/2X/e/e258eb22fdb2c274aeca290b0a1ea810315ff5eb.png)

After doing this, the job should run successfully.