Symptom
SAP Data Services optimized SQL contains the following SQL for an ORDERBY:
ORDER BY "TCRdr_8"."Col2" COLLATE Latin1_General_BIN2 ASC
Even though the source, target and repository database are using the collation Latin1_General_CS_AS and the SAP Data Services AL_Engine is set to <default>_<default>.<default> in the DSConfig.txt
Read more...
Environment
- SAP Data Services 14.2.x
- Microsoft SQL Server 2016
Product
SAP Data Services 4.2
Keywords
DS, TC , KBA , EIM-DS-EXE , Job Execution , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.