Duplicate insert warning in the Database
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 11
- Joined: Tue Nov 21, 2006 3:08 am
- Location: Pune
Duplicate insert warning in the Database
INSERT,0: [DataDirect][ODBC SQL Server Driver][SQL Server]Cannot insert duplicate key row in object 'dbo.TableA' with unique index 'XPKTableA_SEQ'.
Hi
Better filter the data in the source systems itself for duplication handling.
Regards,
Akumar1:)
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...