SAP Knowledge Base Article - Preview

2493350 - OLEDB provider fails to commit after inserting rows into table


When using Microsoft SQL Server Integration Services (SSIS, DTSWizard) to move a table from a Microsoft SQL Server database to SAP SQL Anywhere or SAP IQ, the OLE DB provider failed to commit the rows inserted into the table. No errors are reported.



  • SAP IQ 16.0
  • SAP SQL Anywhere 16


SAP IQ 16.0 ; SAP SQL Anywhere 16.0 ; SAP SQL Anywhere 17.0


OLEDB OLE DB SSIS DTSWizard Microsoft SQL SERVER Integration IQ Anywhere provider rollback committed uncommitted rows silent commit insert inserting 808768 , KBA , BC-SYB-IQ , Sybase IQ , BC-SYB-SQA-CLI , SQL Anywhere - Client libraries (odbc, jdbc ...) , 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.