SAP Knowledge Base Article - Preview

1969721 - Data Services job that bulk loads MS SQL Server target gets a warning message from SQL server

Symptom

  • Data Services batch job uses bulk loading for Microsoft SQL Server database. The job runs successfully and loads the target but gives the warning message "warning message for operation <bulkExecSql>: <>, SQLState <>"
  • The job runs successfully without bulk loading and gives no warning message.
  • The job with bulk loading runs fine without any wanring message if SQL user 'sa' is used to connect or user has db_owner role on target.

 


Read more...

Environment

SAP Data Services 4.x

Product

SAP Data Services 4.0

Keywords

sql sqlstate<> rights ds sa user sql , 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.