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 for Me (Login required).

Search for additional results

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