Error trying to connect to Oracle DB with SSIS?
<p>I'm trying to connect to an Oracle database using SSIS, but I'm getting the following error: </p>

<pre><code>Test connection failed because of an error in initializing provider. Oracle client and 
networking components were not found. These components are supplied by Oracle 
Corporation and are part of the Oracle Version 7.3.3 or later client software installation.
Provider is unable to function until these components are installed.
</code></pre>

<p>A search returned <a href="http://sqlblog.com/blogs/jorg_klein/archive/2011/06/09/ssis-connect-to-oracle-on-a-64-bit-machine.aspx" rel="nofollow">this link</a> and downloaded the zip files in the <a href="http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html" rel="nofollow">Oracle Instant Client</a>. But I have no idea what to do with the contents of these zip files.</p>

<p>Another link also mentions to download <a href="http://www.microsoft.com/en-us/download/details.aspx?id=29284" rel="nofollow">Microsoft Connector for Oracle by Attunity</a>, but again, I don't know what to do with them.</p>

<p>Any help is appreciated.</p>

<p>I'm using Sql Server 2008 R2, Windows Server 2008, and VS2008. I don't exactly what version of Oracle the DB's in.</p>