In my package source table is exist in DB2 and target will be Oracle db, just a simple table to table copy,
when i try to configure connection manager for source, and test i have the below issue, does anybody have idea why i am getting this, and what could i do here to resolve this please?
Provider: Native OLEDB\IBM OLEDB Provider for DB2
OLEDB Provider: IBM OLE DB Provider for DB2
Server or file name: gsk_Wherehouse
TITLE: Connection Manager
Test connection failed because of an error in initializing provider. SQL30081N A communication error has been detected. Communication protocol being used: "TCP/IP". Communication API being used: "SOCKETS". Location where the error was detected: "198.777.66.22". Communication function detecting the error: "connect". Protocol specific error code(s): "10060", "*", "*". SQLSTATE=08001