CODEWITHSUNDEEP
sql-serverssisvisual-studio-2019attunity
Doodle
Doodle

Reputation: 479

VS2019 Oracle connection not working in SSIS

I have installed the Professional version of Visual Studio 2019 and I am unable to connect to Oracle DB Source using the Microsoft connector. I am getting the below error. Can someone please help with this?

TITLE: Microsoft Visual Studio
------------------------------

There was an error trying to establish an Oracle connection with the database server.

------------------------------

Below is all the version information

SQL Server Version Info

SQL Server Management Studio 15.0.18410.0
SQL Server Management Objects (SMO) 16.100.47008.0
Microsoft Analysis Services Client Tools 15.0.19750.0
Microsoft Data Access Components (MDAC) 10.0.17763.1
Microsoft MSXML 3.0 6.0
Microsoft .NET Framework 4.0.30319.42000
Operating System 10.0.17763
Oracle Client version installed 12

Visual Studio Version Info

Microsoft Visual Studio Professional 2019 (2)
Version 16.11.15


Microsoft SQL Server Integration Services Designer
Version 15.0.2000.123

Connectors installed

Attunity connector v5 installed but not visible in the SSIS toolbox

Microsoft Connector for Oracle v1 Installed and visible

Upvotes: 0

Views: 3850

Answers (1)

Doodle
Doodle

Reputation: 479

The solution did not work at all.

Upvotes: 1

Related Questions