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

Symptom

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

Read more...

Environment

  • SAP Data Services
  • Microsoft SQL Server

Product

SAP Data Services all versions

Keywords

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.