Oracle OLE DB Provider not Listed in SSIS
You have to download and install the Oracle Data Access Components (ODAC) 32-bit:
Download Link
Helpful Links
Only this install worked for me (for Visual Studio 2017):https://www.oracle.com/database/technologies/dotnet-utilsoft-downloads.html
Other ways to install OLEDB provider from multiple forums didn't work.