SAP Knowledge Base Article - Preview

2456239 - SQL statement disappears from SQL Transform after upgrading source database - SAP Data Services 4.2

Symptom

  • Upgraded the source database.
  • The database version in Data Services (DS) datastore got changed accordingly.  For example, from Microsoft SQL Server 2008 to 2016.
    datastore_upg.PNG
  • Then the previous SQL statement in SQL Transform disappeared.
    sql1.PNG
    sql2.PNG


Read more...

Environment

SAP Data Services 4.2

Product

SAP Data Services XI 3.2

Keywords

SQL, version, transform, upgrade, disappear , 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.