SAP Knowledge Base Article - Preview

1759806 - Error: [Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near '&' - Data Services XI 3.2

Symptom

  • Global Variables:
    For example, $LastModifyDate = 'select max(LASTMODIFIEDDATE) from "USER"'
  • Microsoft SQL Reserved Keywords
  • Job is terminated due to error <70401>:
    Function call <sql ( DS_SFDC_DB, select max(LASTMODIFIEDDATE) from &quot;USER&quot; a ) > failed, due to error <70401>: <ODBC data source <10.41.11.32> error message for operation <SQLExecute>: <[Microsoft][SQL Server Native Client 10.0][SQL Server]Incorrect syntax near '&'.>.>.


Read more...

Environment

  • Data Services XI 3.2
  • Microsoft SQL Server

Product

SAP Data Services XI 3.2

Keywords

",70401,keyword,ds,sql,&quot; , KBA , EIM-DS , Data Services , 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.