DB2 Transform task Error

Last Post 09 Jul 2007 07:10 PM by nbkr3bi. 1 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
nbkr3bi
New Member
New Member

--
04 Jul 2007 09:11 PM
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

nbkr3bi
New Member
New Member

--
09 Jul 2007 07:10 PM
Yes. The source and the destination is the same


Acceptable Use Policy
---