Solved

Error when trying to open editor in Visual Studio SSIS

  • 22 May 2023
  • 1 reply
  • 138 views

Badge

When double clicking on the CData source, I am getting the following error. 

 

“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.”

 

icon

Best answer by Elizabeth G 23 May 2023, 18:11

View original

1 reply

Userlevel 4
Badge

Thank you for reaching out. It appears that this issue is caused by a bug in the SSIS components that has recently been fixed. Please find the latest build of the SSIS components below, which should fix this issue.

https://cdatabuilds.s3.amazonaws.com/support/OWSHA_8543.exe

Alternatively, you can instead right click your solution and select Properties. In the General section, please set TargetServerVersion to SQL Server 2019.

Reply