SQL Server Performance Forum – Threads Archive

DB2 Transform task Error

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

---

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.

---

]]>