SAP Knowledge Base Article - Preview

2148506 - When transforming and loading data that is in a SQL Server nvarchar(max) datatype, the data is turned into Hex or garbled numbers and letters - Data Services


  • get the data across as character.
  • Data is incorrectly transformed.
  • the SQL Server datatype is nvarchar(max).
  • The Oracle datatype is varchar2(4000)



  • SAP Data Services
  • Microsoft SQL Server


SAP Data Services all versions


KBA , EIM-DS-EXE , Data Services Job Execution , EIM-DS , Data Services (Use Subcomponent) , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.