Windows Oracle Data Access Components (MOSC)

MOSC Banner

Connect to Oracle database from Visual Studio 2019 SSIS project

edited Mar 1, 2023 11:23AM in Windows Oracle Data Access Components (MOSC) 3 commentsAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center