DSXchange

INSERT,0: [DataDirect][ODBC SQL Server Driver][SQL Server]Cannot insert duplicate key row in object 'dbo.TableA' with unique index 'XPKTableA_SEQ'.

i think your write method is upsert and upsert mode is insert only..and you are trying to insert a duplicate record into the table... check whether the option - output reject records is set to true...and try capturing the rejects...

Better filter the data in the source systems itself for duplication handling.

Regards,
Akumar1:)

sanjay.v wrote:i think your write method is upsert and upsert mode is insert only..and you are trying to insert a duplicate record into the table... check whether the option - output reject records is set to true...and try capturing the rejects...