SSIS Package and Oracle connectivity issues with TNS


  • Hi

    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.

    Any thoughts on what might I am missing.

    Thanks in advance.

    Regards, Teenu
    Wednesday, February 09, 2011 8:07 PM