none
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
    יום רביעי 09 פברואר 2011 20:07

תשובות