title: How to fix error 'Ora-12154 TNS could not resolve service name' in SSIS?
body: <p>When MS-SQL Server 2000 dtsx job tries to run, gets error <code>Ora-12154 TNS could not resolve service name</code> Tnsping to the oracle service to connect replies OK. The Windows 2003 x64 Server that runs the dtsx jobs has 32 bit Oracle Server, ODAC 32 bit and Oracle Client 32 bit installed.</p>