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?