SAP Knowledge Base Article - Preview

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

Symptom

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.


Read more...

Environment

  • SAP IQ 16.0
  • SAP SQL Anywhere 16

Product

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

Keywords

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.