SQL Server Data Tools ( SSDT ) – Error – “The Application is not installed”

Background

Wanted to quickly go over an error that is easy to self trigger when working with SQL Server Data Tools ( SSDT ).

 

Triggering Point

A few days ago I was working with SSDT, and I was informed that one of the plugins is running slow and prompted if I want to disable it.

Error

Error Message

Solution Explorer

Here is the visuals from Solution Explorer.

Text

The project is marked “incompatible“.

The project’s packages are not outlined.

Their usual placement is obstructed by a text that reads “The application is not installed“.

Image

solutionExplorer.01.20190704.0637PM.PNG

Textual

The application is not installed.

 

Remediation

Outline

  1. In SQL Server Data Tools ( SSDT )
    • Extensions and Updates
      • Access Menu Options Tools \ “Extensions and Updates”
      • The “Extensions and Updates” Window appears
        • Left Panel
          • From the left panel, access the Installed\All Tab
        • Middle Panel
          • Choose to sort by “Most Recent”
          • Select “Microsoft Integration Services”
          • Click on the “Enable” button
  2. Restart SSDT
  3. Load Project
  4. Access Solution Explorer window
    • Access Project
    • Right click on Project and choose to Reload it

 

Images

Extensions and Updates

Microsoft Integration Services Project

Pre Changes

extensionsAndUpdates.integrationServices.01.20190704.0645AM.PNG

Post Changes

extensionsAndUpdates.integrationServices.02.20190704.0646AM.PNG

Summary

Please keep good notes of changes you make.

And, be ready to go back and revert if need be.

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s