Symptom
- Job is failed when target table is enabled with option: bulkload mode: truncate.
- Error message:
Data flow XX|Loader XX SQL submitted to ODBC data source <XX> resulted in error <[DataDirect][ODBC lib] You are not licensed to use this ODBC driver with the DataDirect ODBC Driver Manager under the license you have purchased.Thank you for your cooperation.>. The SQL submitted is <DELETE FROM `XX`.`XX` WHERE 1=1>.
Read more...
Environment
- SAP Data Services
Product
SAP Data Services 2025 ; SAP Data Services 4.3
Keywords
odbc driver error, sap data services, delete command error, bulkload truncate, ds , 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.
SAP Knowledge Base Article - Preview