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 , 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.