title: Connect SSIS in local machine to a remote server oracle database
body: <p>I have an ssis project in visual studio 2012 in my machine. I want to setup a connection manager to an oracle database that's in a remote server. </p>
  
  <p>I've tried installing oracle and tried several types of connections managers. But I  wasn't able to successfully test the connection in any of them.</p>
  
  <p>What type of connection manager should I use and what software do I need to install in my machine?</p>