Issue with SSIS to connect to Oracle DB using microsoft connector

  • 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.

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

    BUTTONS:

    OK

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

    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+9f71e8549924d85d66afcca2b9f45a33061faa1b

    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

    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

    Attunity connector v5 installed but not visible in the SSIS toolbox

    Microsoft Connector for Oracle v1 Installed and visible

    Oracle Client version installed 12

  • Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

  • Hi if your issue is fixed please post the solution. My first response is validate your tnsnames.ora file. Another thing to check is how connections are made in production.

  • I am using VS 2019 Integration service project. I installed MicrosoftSSISOracleConnectorX64.msi to get the Oracle Source and Destination components. But they are not displayed in my toolbox. Also tried with MicrosoftSSISOracleConnectorX86.msi. No luck.

    I read the Oracle client is NOT needed for OracleConnector component starting 2019 version. Am I missing something? Please suggest how to add the Oracle Source and destination components in SSIS toolbox?

  • Hi, first check and see if you can connect to the Oracle data source using a query tool. Can you do that?

  • Do you have SQL 2019 Enterprise\Developer?  Microsoft connector only works for Enterprise.  Im using Standard and had to use Oracles Latest instant client.

    • This reply was modified 4 months, 4 weeks ago by  BTC100k.
  • Hi, I am able to connect to Oracle data source using SQL developer. I have Visual Studio 2019 Enterprise edition.

    As per https://techcommunity.microsoft.com/t5/sql-server-integration-services/microsoft-connector-for-oracle-is-released-for-sql-server-2019/ba-p/565923 I should be able to see Oracle source and destination in DFT toolbox. Attaching my project Data flow task toolbox screenshot where I don't find Oracle source and destination in "Common" toolbox list.

    I have installed MicrosoftSSISOracleConnector.

     

    • This reply was modified 4 months, 4 weeks ago by  slakshmi29.
    Attachments:
    You must be logged in to view attached files.

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply