Has anyone connected to Oracle from SSIS using Oracle Driver ( 12.1.0 ) from VS 2017 Data Tools SSIS
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.