SSIS component - error on Microsoft.DataWarehouse assembly

Live Connectivity CData Drivers
,
1

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. 
Had another error unrelated to this and the reason why I tried to upgrade.

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

2

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):
<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