SAP Knowledge Base Article - Preview

2640317 - Bulk loading a SQL Server table from data services gives error

Symptom

  • Run a data services job to bulk load a table in Microsoft SQL Server table and application throws following error:                                                                             SQL submitted to ODBC data source <datasource name> resulted in error <[Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid object name 'sys.server_principals'>.The SQL submitted is <SELECT IS_SRVROLEMEMBER('sysadmin', '<datastore username>') AS IsSysAdmin FROM sys.server_principals p WHERE name='<datastore username>'>.
  • Simple loading works fine.

Read more...

Environment

SAP Data Services 4.2

Microsoft SQL Server

Product

SAP Data Services 4.2

Keywords

server_principals, azure, bulkcopy, bulkload, ds, PaaS , KBA , EIM-DS-EXE , Data Services 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.