Has anyone connected to Oracle from SSIS using Oracle Driver ( 12.1.0 ) from VS 2017 Data Tools SSIS I have installed Oracle Driver ( 12.1.0 ) and I have VS 2017 Data Tools SSIS . The connection to Oracle Service from local machine via ODBC 64 bit on my machine is working.

Connection to Oracle Server from SSMS 17 via Linked Server is not working 

I get 'Architecture Mismatch' error when I create a Oracle OLDEB connection from SSIS.
Any ideas how do I access Oracle from SSMS and SSIS  .. 

Thanks,
Shuchi
Visual Studio and SSDT are 32bit programs, so they can't use the 64bit OleDB provider.  You can run your SSIS package in 64bit mode, but the designers don't work unless you also have the 32bit OleDB provider, and are running visual studio using a Path that allows it to load the 32bit OCI.DLL.