title: How do I know which ORA file my SSIS package is using to connect to Oracle 10g?
body: <p>I am maintaining an SSIS package which extracts data from an Oracle 10g database. When the connection timed out with the error code:</p>
  <blockquote>
  <p>Test connection failed because of an error in initializing provider. ORA-12170: TNS:Connect timeout occurred</p>
  </blockquote>
  <p>I was told that I should change the sqlnet.ora or tnsnames.ora. This raises an interesting question. How can I find which ora file is being used by SSIS, other than changing them one by one until the problem goes away?</p>
  <p>I should add that I have tnsnames.ora files in two directories that aren't named something like backup or _old</p>
  <blockquote>
  <p>D:\oracle\product\11.2.0\client_1\NETWORK\ADMIN</p>
  <p>D:\oracle\product\11.2.0\client_2_32_bit\NETWORK\ADMIN</p>
  </blockquote>