Jitterbit · Database connector (SQL Server)

Cannot insert explicit value for identity column

Short answer

This Jitterbit SQL Server error means the identity column is included in the INSERT the connector generates while IDENTITY_INSERT is OFF. To let SQL Server assign identity values, map the identity target field with Unmap.

VerifiedLast verified

01Error text

Jitterbit error
Database Error: Cannot insert explicit value for identity column in table '<table>' when IDENTITY_INSERT is set to OFF.

02Likely causes

  • The identity column is included in the INSERT the connector generates.
  • Mapping the field to a null value does not exclude it. Only the Unmap function removes a target field from the INSERT.

03How to fix it

  1. To let SQL Server assign identity values, map the identity target field with Unmap.
  2. If you must insert explicit values, set IDENTITY_INSERT on the target table in the activity's pre- and post-SQL scripts.

04Official documentation

Test every fix in a non-production environment before you apply it to production. See how entries are verified.

More for Jitterbit work:Open Jitterbit jobsJitterbit rates and salaries

The iPaaS Brief

Subscribe to The iPaaS Brief.

The iPaaS newsletter for the people who run integrations. From iPaaS Group.

Free. You finish on theipaasbrief.com and confirm by email.