Connect to Oracle database from Visual Studio 2019 SSIS project
I am using Visual Studio to create an SSIS package to get data from an Oracle database to use in SQL Server. Having created the dtsx file on my local development machine, I then need to copy this to my server so I can run it from a scheduled job.
Development environment: Windows 10 64-bit, VS 2019 with SSIS designer.
Target server: SQL Server 2019 Standard Edition (not Enterprise or Developer)
Oracle database: Version 19c Enterprise Edition
What I've tried so far. I am trying to add a connection manager into the package, and have tried both ".Net Providers\OracleClient Data Provider" and ".Net Providers for OleDb\Microsoft OLE DB Provider for Oracle". The first of these tells me I need "Oracle client software version 8.1.7 or greater", and the second tells me I need Oracle client and networking components, which are part of the "Oracle Version 7.3.3 client software installation". I have tried to find Oracle client software on the Oracle site, but don't see anything with these sorts of version numbers. All I can find is "Oracle