We have SSIS package which connects Oracle and fetch data to insert into Tables in SQL Server 2005.
We are facing connectivity issues and below is the error;
Test connection failed because of an error in initializing provider. ORA-12154: TNS:could not resolve the connect identifier specified
I tried verifying TNSNames.ora file and this is inplace with appropriate values. We could connect to oracel server while we trying to login through oracle client and also while test connection while we create DSNs in Microsoft ODBC Administrator; but we
could not connect through SSIS package.