Issue:  After upgrading from TIBCO Scribe Insight 7.8.0 to 7.9.2, a DTS that ran without error in 7.8.0 now returns the following error:

 [23000] SQL call failed. Cannot insert explicit value for identity column in table when IDENTITY_INSERT is set to OFF.

The target SQL table contains an identity column.  I am not explicitly setting the identity value in the integration, and “Allow auto foreign key assignment” is not enabled on the step.  Where is the IDENTITY_INSERT set?

Resolution:  Uncheck "Allow auto foreign key assignment" from each step in the DTS to ensure the identity column is not mapped.

1. Open DTS and click on Configure Steps
2. Select each Step, select the Operation tab, and uncheck the "Allow auto foreign key assignment" option.
3. Save the DTS