3409881 - Error: "Cannot insert duplicate key in object" occurs when using Table_Comparison to MSSQL table - SAP Data Services

• Job is successful without any errors when doing Table_Comparison to Oracle table
• The same job fails with below error when doing Table_Comparison to MSSQL table(compared target tables of Oracle and MSSQL are completely same just with different database types)
• Error: "<[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Violation of PRIMARY KEY constraint 'xxx'. Cannot insert duplicate key in object 'xxx'. The duplicate key value is (xxx, xxx,...)"
• All of the duplicate key values in error messages have Chinese/Japanese characters
• By enabling Trace: SQL Loaders=Yes when executing the job, Data Services produces INSERT SQL statements to MSSQL compared table but produces UPDATE SQL statements to Oracle compared table

• SAP Data Services
• Microsoft SQL Server

MSSQL, collation order, Japanese_XJIS_140_CS_AS_KS_WS_VSS_UTF8, default, codepage, SQL_Latin1_General_CP1_CI_AS, utf-8, shift_jis, Table_Comparison, duplicated, primary key, Chinese characters, insert, update, SQL , KBA , EIM-DS-EXE , Job Execution , Problem