char and nchar datatype values are intended to preserve the trailing whitespace from source database, but Data Services is trimming the values and thus losing the trailing whitespace
i.e. "hello " is appearing as "hello" in output when it should be appearing as "hello "
- SAP Data Services
- Microsoft SQL Server
SAP Data Services 4.2
missing, removed, blank, space , 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.