# SSIS component - error on Microsoft.DataWarehouse assembly

**URL:** <https://community.cdata.com/t/ssis-component-error-on-microsoft-datawarehouse-assembly/1001>\
**Category:** CData Drivers\
**Tags:** question, ssis\
**Created:** [January 23, 2025, 1:29pm UTC](https://community.cdata.com/t/ssis-component-error-on-microsoft-datawarehouse-assembly/1001 "2025-01-23T13:29:47Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![dvinge](https://avatars.discourse-cdn.com/v4/letter/d/8e8cbc/32.png) [@dvinge](https://community.cdata.com/u/dvinge)\
**Post date:** [January 23, 2025, 1:29pm UTC](https://community.cdata.com/t/ssis-component-error-on-microsoft-datawarehouse-assembly/1001/1 "2025-01-23T13:29:48Z")

</div>

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

Could not load file or assembly ‘Microsoft.DataWarehouse, Version=17.3.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91’ or one of its dependencies. The system cannot find the file specified

It appears after installing the SSIS component for monday 2024 (Build 24.0.9111)

Running VS 2019 and the target SQL Server is 2022

Previously i was running monday 2023 (Build 23.0.8839) without this error.&nbsp;  
Had another error unrelated to this and the reason why I&nbsp;tried to upgrade.

I have tried to uninstall and reinstall the old version again but the error remains

---

<div class="post-metadata">

**Author:** ![Naomi\_Y](https://avatars.discourse-cdn.com/v4/letter/n/ea666f/32.png) [@Naomi\_Y](https://community.cdata.com/u/Naomi_Y)\
**Post date:** [January 24, 2025, 4:53pm UTC](https://community.cdata.com/t/ssis-component-error-on-microsoft-datawarehouse-assembly/1001/2 "2025-01-24T16:53:48Z")

</div>

Thank you for reaching out and bringing this error to our attention. This error can occur when targeting SQL Server 2022 with Visual Studio 2019 due to compatibility issues. To resolve this error, you can follow the instructions below.

Process for Visual Studio 2019 targeting SQL Server 2022:

1. Open the file “C:\Program Files (x86)\Microsoft Visual Studio\2019\ **\<EDITION\>** \Common7\IDE\devenv.exe.config” in a text editor
2. Add the following values under the \<assemblyBinding xmlns=“urn:schemas-microsoft-com:asm.v1”\> element (directly before the \<probing\> element):

```auto
<dependentAssembly> <assemblyIdentity name="Microsoft.SqlServer.DlgGrid" publicKeyToken="89845dcd8080cc91" culture="neutral"/> <bindingRedirect oldVersion="10.0.0.0-20.0.0.0" newVersion="15.0.0.0"/></dependentAssembly><dependentAssembly> <assemblyIdentity name="Microsoft.SqlServer.GridControl" publicKeyToken="89845dcd8080cc91" culture="neutral"/> <bindingRedirect oldVersion="10.0.0.0-20.0.0.0" newVersion="15.0.0.0"/></dependentAssembly><dependentAssembly> <assemblyIdentity name="Microsoft.DataWarehouse" publicKeyToken="89845dcd8080cc91" culture="neutral"/> <bindingRedirect oldVersion="10.0.0.0-20.0.0.0" newVersion="15.0.0.0"/></dependentAssembly><dependentAssembly> <assemblyIdentity name="Microsoft.DataWarehouse.Interfaces" publicKeyToken="89845dcd8080cc91" culture="neutral"/> <bindingRedirect oldVersion="10.0.0.0-20.0.0.0" newVersion="15.0.0.0"/></dependentAssembly>

```

1. Navigate to C:\Users\ **\<USERNAME\>** \AppData\Local\Microsoft\VisualStudio.

- For each **16.0\_\<ID\>** folder, open it and make a backup of **devenv.exe.config** with a different extension (ex: rename to **devenv.exe.oldconfig** ). Revert to the backup if any problems are encountered with usual Visual Studio usage and contact CData Support for help.
- Delete the original **devenv.exe.config** file in these folders (NOTE: do **NOT** delete the devenv.exe.config file in Program Files. The AppData files will be regenerated from that one).

1. Open Visual Studio to regenerate the **devenv.exe.config** file in AppData

2. You should now be able to develop SSIS packages in Visual Studio 2019 targeting SQL Server 2022 with the CData components