I am trying to use an Oracle OleDb source in my SSIS package with no luck, every time I try to connect to the server I get the error:
ORA-12154 tns could not resolve the connect identifier specified
, knowing that:
1 I installed Oracle 11g express edition
2 I added an entry for the alias in my tnsnames.ora file
3 ORACLE_HOME variable pointing to my Oracle installation
4 Path & TNS_ADMIN variables pointing to the directory containing the tnsnames.ora file
5 I am using a Windows Server 2012
What am I doing wrong?
