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 ..