I need to read and import into a SQL Server 2012 db data from an Oracle data source (Oracle 11g R2).
I think to use the Oracle provider for OLE DB, but I need to download and install something on the db server that hosts SQL Server 2012. What do I need to install? 32-bit or 64-bit?
Then the data provider setup, how will I use it inside SSIS 2012?