SAP Knowledge Base Article - Preview

2699151 - SQL Server synonyms not importing in Data Services Designer


  • When you try to import a synonym from a Microsoft SQL Server datastore, the table does not appear in the list of available imports
  • Unable to reference a Synonym using an SQL Transform
  • Cannot see SQL Server synonyms in the list of tables.
  • Cannot find the SQL Server synonym when searching the external objects of the datastore.



  • SAP Data Services
  • Microsoft SQL Server


SAP Data Services 4.2


KBA , EIM-DS-DES , User Interface/Designer , EIM-DS-EXE , Job Execution , Product Enhancement

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.