1969721 - Warning message: "warning message for operation <bulkExecSql>: <>, SQLState <>" occurs when job bulk loading to MSSQL target - SAP Data Services

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

SAP Data Services 4.x

sql, sqlstate<>, rights, ds, sa, user, sql, MSSQL, db_owner, bulkload, warning, target, DB , KBA , EIM-DS-EXE , Job Execution , Problem