This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(70.4, 73%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAH%3C/text%3E%3C/svg%3E)
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)
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(96, 26%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYK%3C/text%3E%3C/svg%3E)
c:\Program Files (x86)\Microsoft Visual Studio\2019\Professional\Common7\IDE\CommonExtensions\Microsoft\SSIS\160\BIShared\Microsoft.DataWarehouse.dll
@Yitzhak Khabinsky We have tried both v1.2 and v1.3 as well as uninstalling/reinstalling both.
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.
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:
Please try to fix it by the following steps:
we have tried repairing as well. We are still getting the same error from the oracle components even after a repair.