|
| Hi!
Enviroment: Windows Server 2003; MS SQL 2000 (sp3); DB2 UDB 8.2 (sp8) for win
Both RDBMS is on the same machine.
Connection for DB2 is made with IBM DB2 ODBC driver.
Moving data ,with Data Pumt Task, from from DB2 and to MS SQL works fine.
But when the DTS has to INSERT data from MS SQL into DB2 ..just this emsg ::
********************
*******************
Execution Started: 2005. 09. 27. 13:12:22
@@LogSourceRows: C:\SOURCE_SYS_DTS\OD
BC_0927.txt.Source
@@LogDestRows: C:\SOURCE_SYS_DTS\OD
BC_0927.txt.Dest
@@ErrorRow: 1
Error at Destination for Row number 1. Errors encountered so far in this
task: 1.
Error Source: Microsoft OLE DB Provider for ODBC Drivers
Error Description:[IBM][CLI Driver] CLI0150E Driver not capable.
SQLSTATE=S1C00
Error Help File:
Error Help Context ID:0
@@SourceRow: Logged
@@DestRow: Logged
@@ExecutionCompleted
Execution Completed: 2005. 09. 27. 13:12:22
********************
********************
*************
This test DTS has only one column to move to the dest..It's a NAME
varchar(50) column..so nothing special..date etc..just varchar on both side.
I tried to INSERT one row to DB2 with Execute SQL Task ( with the same ODBC
connection), you know, just a simple INSERT INTO VALUES etc. and just worked
fine....so may be the Data Pump cause the problem?
Any idea?
--
Zsolt
(viv la stout:)
|
|