Skip to main content
Solved

Error when trying to open editor in Visual Studio SSIS

  • May 22, 2023
  • 1 reply
  • 536 views

Forum|alt.badge.img

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

 

Best answer by Elizabeth G

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.

This topic has been closed for replies.

1 reply

Forum|alt.badge.img
  • Employee
  • Answer
  • May 23, 2023

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.