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

Question

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

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)

Answer 1

@Amanda Hansen,

Please try to fix it by the following steps:

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

Answer 2

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.