SAP Knowledge Base Article - Preview

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


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



SAP Data Services 4.2

Microsoft SQL Server


SAP Data Services 4.2


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 ONE Support launchpad (Login required).

Search for additional results

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