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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.