SQL DTS to DB2

[Nali]

I created an ODBC connection to a DB2 instance running on Linux. Using
SQL 2000 DTS package,I can read data from DB2 and populate SQL tables.
However when I try to write to DB2 tables, I get the error:

The number of failing rows exceeds the maximum specified. [IBM][CLI
Driver] CLIO15OE Driver not capable. SQLSTATE=S1C00

The DTS is able to create tables on DB2, but can't populate them. Also,
using Microsoft Access, I can write from SQL to DB2. Why can't I do it
with the SQL 2000 DTS?

I've tried DB2 versions 7 and 8.

[Fred Morrison]

Are you using a Data Pump task in your DTS package?

Does the Destination DB2 table have a PRIMARY KEY on it?

Does your Transformation within the Data Pump Task write to all the required
(NOT NULL) columns of the DB2 table?

Try a simple SQL Task that uses the DB2 connection and one INSERT of one
record of hard-coded values to be sure you have a connection that is more
than just read-only.

"Nali" <St***********@gmail.comwrote in message
news:11**********************@i3g2000cwc.googlegro ups.com...

>I created an ODBC connection to a DB2 instance running on Linux. Using
SQL 2000 DTS package,I can read data from DB2 and populate SQL tables.
However when I try to write to DB2 tables, I get the error:

The number of failing rows exceeds the maximum specified. [IBM][CLI
Driver] CLIO15OE Driver not capable. SQLSTATE=S1C00

The DTS is able to create tables on DB2, but can't populate them. Also,
using Microsoft Access, I can write from SQL to DB2. Why can't I do it
with the SQL 2000 DTS?

I've tried DB2 versions 7 and 8.