DSXchange

Hi

when iam inserting the data in the table i am getting the error as shown below

APT_CombinedOperatorController,0: [IBM(DataDirect OEM)][ODBC SQL Server Driver][SQL Server]Cannot insert explicit value for identity column in table 'Table_Name'when IDENTITY_INSERT is set to OFF.

for the table we had select ,delete,update and insert previlages,
so how to resolve it?

Are you trying to insert values in identity column? Could you please check your table's ddl script.

Talk to your DBA. That or stop trying to insert explicit values into the IDENTITY column.