title: Oracle Install for SSIS connectivity (and drivers 32 64 bit)
body: <p>I have an SSIS package (SQL 2008) that I need to connecto to an Oracle DB (11g) with. What do I need to install to connect to oracle? What's the terminology ? All searches I've done talk about Instant Client, but on downloading that I see no exe's? I know installing the server will give me that Oracle Net manager (UI to update TNSNames.ora) but I don't want to install the entire server. That to be is overkill. What's the smallest footprint so that I can create a connection to an oracle DB via my Connection Manager in SSIS?</p>
  
  <p>Also what's the difference between <em>Instant Client</em> &amp; <em>Oracle Client tools</em> etc? There's so much arcane (atleast to me) terminology that it's confusing.</p>
  
  <p>P.s. - From reading <a href="http://www.oracle.com/technetwork/topics/dotnet/index-085163.html" rel="noreferrer">http://www.oracle.com/technetwork/topics/dotnet/index-085163.html</a> you would think this was what I wanted, but the download just has an install.bat that seems to do nothing! Typical of the "solutions" I've tried so far.</p>