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: "126.96.36.199". 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 context: 0
The funny thing is that if i run the the 4th part in a seperate DTS it works fine.