Clever Geek Handbook

DB2 DTS connection problem

I want to copy an Oracle database to DB2 using DTS in SQL Server 2000.

When I set up both connections with my respective driver, I can read both databases and bind copy operations between them.

But when I want to run the DTS package, the "Driver not able" error appears.

Here is the magazine, thanks in advance.

Step 'DTSStep_DTSDataPumpTask_1' failed

Step Error Source: Microsoft Data Transformation Service (DTS) Data Pump Step Error Description: The number of failed 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 Error Help Step Context ID: 0

+1


source to share


2 answers


My suggestion was to check the driver information and see if you can get a newer version from Microsoft or IBM. You can also try connecting to an ODBC connection from the machine's DSN. I believe a lot of people ran into this issue when upgrading to SP 4 SQL Server 2000.



0


source


Have you tried to clear the Use Transactions check box on the Advanced tab of the DTS Package Properties?



0


source






More articles:


All Articles