SQL Server Performance

DB2 Transform task Error

Discussion in 'SQL Server DTS-Related Questions' started by nbkr3bi, Jul 4, 2007.

  1. nbkr3bi New Member

    DB2 Transform task Error

    I have a DTS package that is invoked by a job that has 3 transform data tasks that connect to a DB2 server (using IBM DB2 CLI DRIVER) and fetch data into my Sql database.
    Recently a 4th transform data task was added in the DTS. Now it started to fail at the 4th task and gives some communication error message :

    Error: -2147467259 (80004005); Provider Error: 30081 (7581)

    Error string: [IBM][CLI Driver] SQL30081N A communication error has been detected. Communication protocol being used: "TCP/IP". Communication API being used: "SOCKETS". Location where the error was detected: "171.160.1.1". Communication function detecting the error: "recv". Protocol specific error code(s): "10054", "*", "0". SQLSTATE=08001



    Error source: Microsoft OLE DB Provider for ODBC Drivers

    Help file:

    Help context: 0


    The funny thing is that if i run the the 4th part in a seperate DTS it works fine.
    Please help
  2. satya Moderator

    http://www.experts-exchange.com/Database/DB2/Q_20487044.html#a7837553 for a resolution with similar error.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.

Share This Page