SAP Knowledge Base Article - Preview

2046928 - Data Services writing null instead of blank


  1. Data Services job writes to a column defined as not null at database level. nvl(source column,'') mapping for such columns is trying to write null instead of a blank to target column if source column is empty.
  2. This worked fine in DS 14.0 SP2 Patch 4 as it inserted null.



SAP Data Services 4.x


SAP Data Services 4.0 ; SAP Data Services 4.1 ; SAP Data Services 4.2


null, NULL, nvl, empty, ds , 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 ONE Support launchpad (Login required).

Search for additional results

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