Post reply

DTS to DB2

  • August 14, 2006 at 12:00 pm

    #61606

    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

  • August 14, 2006 at 2:46 pm

    #654950

    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

  • August 17, 2006 at 8:56 am

    #655468

    Ok, this is the log:

    The execution of the following DTS Package failed:

    Error Source: Microsoft Data Transformation Services (DTS) Package

    Error Descriptionackage 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

    ****************************************************************************************************

  • August 17, 2006 at 12:40 pm

    #655516

    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

  • September 14, 2006 at 12:30 pm

    #660495

    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

    http://publib.boulder.ibm.com/infocenter/db2luw/v8/index.jsp?topic=/com.ibm.db2.udb.doc/ad/r0011322.htm

     

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply