DTS to DB2
-
I am trying to move data back and forth between SQL 2000 and DB2 running on Linux, using a DTS package. I can retrieve data from DB2 fine into SQL. However when I try to go the other way I get the following error when I kick off the DTS: The number of failing rows exceeds the maximum specified.
An ideas?
Thanks...Nali
-
Nali,
You'll need more information to troubleshoot this. Enable package logging in Package Properties Logging tab. Execute the package and look in the log.
Greg
Greg
-
Ok, this is the log:
The execution of the following DTS Package failed:
Error Source: Microsoft Data Transformation Services (DTS) Package
Error Description
ackage failed because Step 'Copy Data from unld_itmimprtDEV to "DB2INST1"."UNLD_ITMIMPRT_DEV" Step' failed.Error code: 80040428
\Error Help File:sqldts80.hlp
Error Help Context ID:700
Package Name: Test3
Package Description: DTS package description
Package ID: {71E01DA2-8389-48F3-B597-CA54D2BB8784}
Package Version: {C7B78093-889D-4305-8CBF-91B850CD7A29}
Package Execution Lineage: {CC5D276C-5FDB-47D1-92AF-8A3D3A26EC8F}
Executed On: STORE0698
Executed By: nali
Execution Started: 8/17/2006 10:52:43 AM
Execution Completed: 8/17/2006 10:52:43 AM
Total Execution Time: 0.078 seconds
Package Steps execution information:
Step 'Copy Data from unld_itmimprtDEV to "DB2INST1"."UNLD_ITMIMPRT_DEV" Step' failed
Step Error Source: Microsoft Data Transformation Services (DTS) Data Pump
Step Error Description:The number of failing rows exceeds the maximum specified. (Microsoft OLE DB Provider for ODBC Drivers (80004005): [IBM][CLI Driver] CLI0150E Driver not capable. SQLSTATE=S1C00)
Step Error code: 8004206A
Step Error Help File:sqldts80.hlp
Step Error Help Context ID:0
Step Execution Started: 8/17/2006 10:52:43 AM
Step Execution Completed: 8/17/2006 10:52:43 AM
Total Step Execution Time: 0.062 seconds
Progress count in Step: 0
****************************************************************************************************
-
I'd say this line is a clue, though I haven't seen this problem before.
(Microsoft OLE DB Provider for ODBC Drivers (80004005): [IBM][CLI Driver] CLI0150E Driver not capable. SQLSTATE=S1C00)
Maybe search on this site and Google for an explanation?
Greg
Greg
-
I FINALLY found a solution to this.
In case someone faces this problem in the future, here is the solution:
On the Windows server, open a command promt, type db2cmd enter. This will open a second shell window called DB2 CLP. In this new shell window, issue this command replacing the word "sample" to the name of your database: db2 update cli cfg for section sample using cursortypes 0
You should now be able to read from and write to tables on the DB2 database.
This command makes the cursors forward only. It seems that SQL does not like scrollable cursors, so this forces the cursor to be reported as forward only. Additional information can be "excavated" from IBM at
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply