ERROR: IDENTITY_INSERT is set to OFF.

gooogle · Post by **gooogle** » Wed Jul 21, 2010 12:16 pm

I am doing SQL server table from Database A
to SQl server table in Database B

Getting this warning and job gets aborted.

DataStage][SQL Client][ODBC][IBM (DataDirect OEM)][ODBC SQL Server Driver][SQL Server]Cannot insert explicit value for identity column in table 'STTLMNT_PRCS' when IDENTITY_INSERT is set to OFF.

Any hints ?

Thanks

anbu · Post by **anbu** » Wed Jul 21, 2010 12:20 pm

Two posts turned up when i searched with keywords "Cannot insert explicit value for identity column in table". Check if that helps you

gooogle · Post by **gooogle** » Wed Jul 21, 2010 12:46 pm

I changed it to
SET IDENTITY_INSERT STTLMNT_PRCS ON;

but I am getting the exact same error !

chulett · Post by **chulett** » Wed Jul 21, 2010 5:26 pm

You changed what "it"? And where exactly did you make this change?