Community

INSERTS from DTS to DB2 Through OLE DB Provider for DB2 May Not Work Correctly

If a DTS package is built to export a SQL Server table to DB2/MVS (version 5.1) by using the Microsoft OLE DB Provider for DB2 (DB2OLEDB) and the AUTOCOMMIT property of the provider is set to FALSE, the following error may be reported: [OLE/DB provider returned message: A SQL error has occurred.

Read More - Register for Free Membership

Tags: