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.