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
ERROR: IDENTITY_INSERT is set to OFF.
Moderators: chulett, rschirm, roy