When double clicking on the CData source, I am getting the following error.
“Could not load file or assembly 'Microsoft.DataWarehouse, Version=126.96.36.199, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The system cannot find the file specified.”
Best answer by Elizabeth GView original
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.
Alternatively, you can instead right click your solution and select Properties. In the General section, please set TargetServerVersion to SQL Server 2019.