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.”
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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.