Error loading Oracle components in VS 2019 after SSIS upgrade to version 4.6 and rollback to 3.16

Question

Error loading Oracle components in VS 2019 after SSIS upgrade to version 4.6 and rollback to 3.16

Amanda Hansen 0

I'm getting the following error when attempting to open an Oracle source, destination, or connection manager in VS 2019.

User's image

The text version of the above screenshot and message details are in the code block below.

We began encountering this error after upgrading SQL Server integration services from version 3.16 to the latest version 4.6 and then rolling back to 3.16 after finding out that these oracle components are incompatible with any SSIS version past 3.16.

So far we have tried completely uninstalling visual studio 2019 and all our extensions and then reinstalling all. We've also tried VS 2022. All options we have tried so far have not made any improvements. Currently we are on VS version 16.11.37

How can we fix this error, has anyone else run into this issue?

TITLE: Microsoft Visual Studio  ------------------------------  Could not load file or assembly 'Microsoft.DataWarehouse, Version=15.23.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.  ------------------------------  BUTTONS:  OK  ------------------------------     at Microsoft.DataTransformationServices.DataFlowUI.ORACLEConnectionPage..ctor()     at Microsoft.DataTransformationServices.DataFlowUI.ORACLEDestinationUI.AddOracleConnectionPage(DataFlowComponentForm form, String helpKeyword)     at Microsoft.DataTransformationServices.DataFlowUI.ORACLEDestinationUI.AddPagesToForm(DataFlowComponentForm form)     at Microsoft.DataTransformationServices.DataFlowUI.DataFlowComponentUI.EditImpl(IWin32Window parentControl)     at Microsoft.DataTransformationServices.DataFlowUI.DataFlowComponentUI.Edit(IWin32Window parentWindow, Variables variables, Connections connections)

Yitzhak Khabinsky 26,576 Reputation points

2024-06-20T20:20:20.26+00:00
@Amanda Hansen,

Are you using Microsoft Connector for Oracle v1.3?

On my machine, the assembly in question is located here:

c:\Program Files (x86)\Microsoft Visual Studio\2019\Professional\Common7\IDE\CommonExtensions\Microsoft\SSIS\160\BIShared\Microsoft.DataWarehouse.dll

Here is its version:
Amanda Hansen 0 Reputation points

2024-06-20T20:23:07.1366667+00:00

@Yitzhak Khabinsky We have tried both v1.2 and v1.3 as well as uninstalling/reinstalling both.
Yitzhak Khabinsky 26,576 Reputation points

2024-06-20T20:33:18.83+00:00

@Amanda Hansen,

The original v1.3 was buggy, due to not being Digitally Signed.

Microsoft fixed it later.

Please try to download its latest build/edition from the Microsoft site.
Amanda Hansen 0 Reputation points

2024-06-20T20:53:24.6966667+00:00

@Yitzhak Khabinsky ,

On my machine the assembly is located at: C:\Program Files (x86)\Microsoft Visual Studio\2019\Professional\Common7\IDE\CommonExtensions\Microsoft\SSIS\150\BIShared\Microsoft.DataWarehouse.dll

here are it's details:

I have just installed the latest version of 1.3 from https://www.microsoft.com/en-us/download/details.aspx?id=105811

Interestingly, the details of that assembly did not change after the install of the latest version of v1.3. I continue to get the same error when attempting to open an oracle source/destination/connection manager:

2 answers

Your answer

Yitzhak Khabinsky 26,576 Reputation points

2024-06-20T20:20:20.26+00:00

@Amanda Hansen,

Are you using Microsoft Connector for Oracle v1.3?

On my machine, the assembly in question is located here:

c:\Program Files (x86)\Microsoft Visual Studio\2019\Professional\Common7\IDE\CommonExtensions\Microsoft\SSIS\160\BIShared\Microsoft.DataWarehouse.dll

Here is its version:
Amanda Hansen 0 Reputation points

2024-06-20T20:23:07.1366667+00:00

@Yitzhak Khabinsky We have tried both v1.2 and v1.3 as well as uninstalling/reinstalling both.
Yitzhak Khabinsky 26,576 Reputation points

2024-06-20T20:33:18.83+00:00

@Amanda Hansen,

The original v1.3 was buggy, due to not being Digitally Signed.

Microsoft fixed it later.

Please try to download its latest build/edition from the Microsoft site.
Amanda Hansen 0 Reputation points

2024-06-20T20:53:24.6966667+00:00

@Yitzhak Khabinsky ,

On my machine the assembly is located at: C:\Program Files (x86)\Microsoft Visual Studio\2019\Professional\Common7\IDE\CommonExtensions\Microsoft\SSIS\150\BIShared\Microsoft.DataWarehouse.dll

here are it's details:

I have just installed the latest version of 1.3 from https://www.microsoft.com/en-us/download/details.aspx?id=105811

Interestingly, the details of that assembly did not change after the install of the latest version of v1.3. I continue to get the same error when attempting to open an oracle source/destination/connection manager:

Answer 1

Amanda Hansen 0

After months of troubleshooting, and finally, opening a support ticket with Microsoft this is the fix to our issue:

1.uninstall integration services completely using both the control panel and VS extensions manager. We had to do this a couple of times until "Microsoft SQL Server Integration Services Projects" no longer appeared in the control panel:

2.install integration services 4.6: https://marketplace.visualstudio.com/items?itemName=SSIS.SqlServerIntegrationServicesProjects

3.install the microsoft oracle connectors v1.2 and this is the important part... VERSION SSIS 2022 x64: https://www.microsoft.com/en-au/download/details.aspx?id=104113

we've always tried installing the 2019 versions since that is the version of VS that we are on, but installing the 2022 version to our Visual studio 2019 server fixed the issue. We can now open the oracle components without the error.

Ramello, Abel 0 Reputation points

2024-09-02T13:56:20.9766667+00:00

Hi Amanda!
I have the same issue, and I couldn´t fix it.
Your links not works for me, Can you give me others links please?
Amanda Hansen 0 Reputation points

2024-09-03T13:36:57.44+00:00

Hi @Abel Ramello I'm not sure why the links aren't working when clicked on. But I got them to work for me when I copy/paste them into my browser rather than clicking on the link.

If that doesn't work I'd just try searching for "SQL Server Integration Services download" and selecting version 4.6.

And then searching for "Microsoft Connector for Oracle V1.2" and downloading the version "MicrosoftSSISOracleConnector-SQL22-x64.msi"
Erik Wigbout 0 Reputation points

2025-05-20T13:30:48.8266667+00:00

Thanks, I had the exact same issue. this works for me as well. In my case the v1.3 of the oracle connector is working as well. Thanks for sharing you're solution. I was getting quite desperate. Crazy all these different tools and drivers

Answer 2

Yitzhak Khabinsky 26,576

@Amanda Hansen,

Please try to fix it by the following steps:

OS Start Button, and launch Visual Studio Installer for VS 2019.
Click "Modify button".
Select "Individual components" tab.
Scroll maximum down, and select all three check boxes.
Please see below.

Microsoft BI Shared Components for Visual Studio 2024-06-20 170822

Amanda Hansen 0 Reputation points

2024-06-21T19:54:53.9333333+00:00

we have tried repairing as well. We are still getting the same error from the oracle components even after a repair.

Share via

Error loading Oracle components in VS 2019 after SSIS upgrade to version 4.6 and rollback to 3.16

2 answers

Your answer