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
- SAP Data Services 14.2.x
- Microsoft SQL Server 2016
DS, TC , KBA , EIM-DS-EXE , Job Execution , Problem
About this pageThis 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.