How can I resolve the error "Could not load file or assembly 'Microsoft.DataWarehouse.AS'" in SSIS? I launched good old Visual Studio 2017 today to create a new Integration Services project/package. When attempting to add a new target destination (OLE DB connection), upon selecting the drop down menu for the Table/View, I was greeted with an exciting message:

Could not retrieve the table information for the connection manager
'MyFancyConnection.Server'.
Could not load file or assembly
'Microsoft.DataWarehouse.AS' or one of its dependencies. The system
cannot find the file specified.

I tried upgrading my local SQL Server 2017 to the latest CU16, this did not resolve the issue.
How can I resuscitate my Visual Studio installation?
I was able to defeat the error by uninstalling these two extensions for Visual Studio:


Microsoft Reporting Services Projects
Microsoft Analysis Services Projects


Then I reinstalled the latest SSDT for VS 2017. 

On installation, I chose all 3 options (Analysis Services, Integration Services, Reporting Services). Although I would bet the only requirement to solve the problem would be AS as the original error referenced AS specifically.