Cannot insert explicit value for identity column

Error:

When executing my database target, I'm encountering the following error

 

Error in SQL Query.Cannot insert explicit value for identity column in table 'TABLE_TEST' when IDENTITY_INSERT is set to OFF.]]>

 

Cause:

The SQL database does not allow for insertion of a value into the identity column

 

Solution:

This property would need to be set on the target database (SQL Server). Here's more information from Microsoft

 

Have more questions? Submit a request

0 Comments

Article is closed for comments.