If you want to install Microsoft Business Intelligence (MSBI ) – SSIS , Analysis Services & Reporting Services using latest version of Visual Studio – 2019 ( at the time of writing blog ) , the first thing that you need to do is to Download Visual Studio . You can either search on Google for Microsoft Visual Studio 2019 Community or directly download from the below link
For people who already have a license to Visual Studio 2019:
- For SQL Database Projects, install the Data storage and Processing workload for Visual Studio
- For Analysis Services, Integration Services or Reporting Services projects, install the appropriate extension(s) from the marketplace
For people who don’t have a Visual Studio 2019:
- Install Visual Studio 2019 Community
- Install the Analysis Services, Integration Services or Reporting Services extension as appropriate
We will explore the steps for people who don’t have a Visual Studio licence in detail below so that we don’t face any problem
Installation of Visual Studio 2019 and SQL Server Data Tools before adding Extension SSIS ,Analysis Services & Reporting Services
Once you reach this page, Click & Download the Community Edition
It will take a while to Download . Once the download Completes you will be able to see the below screen . You can install a large number of things from below based on your development requirements . For SSIS , SSAS , SSRS we need to install the Sql Server Data Tools . Select as below and click on install
Once the installation completes the below screen opens up . But you will not have SSIS , SSAS , SSRS right now . You will need to get it from extension.
Now in order to install SSIS , you will need to get it from “Extension” as below .
To Install SSIS – Microsoft Sql Server Integration Services Extension,
Click on “Extensions” from the toolbar, Click on Online on the Left-Hand side and the Search for Microsoft Reporting Services
It will be downloaded as an exe . Double click to install . Before Installing , Close your Visual Studio as we are trying to make changes to it while open so we will receive error .
In the next Step you have to choose the Visual Studio where you want to install SSIS (see screen below). If you have your Visual Studio still open, you will get error after this step as you have not closed Visual Studio and trying to make changes to it.
Once you click on Install and give permission, the SSIS will start getting installed.
Once the installation completes you will see the below confirmation.
Installation of SSAS & SSRS Microsoft Analysis & Reporting Services Extension
To Install Microsoft Analysis & Reporting Services Extension , click on “Extensions” from the toolbar , Click on Online on the Left Hand side and then Search for Microsoft Analysis & Reporting Services. This will start Downloading in the Application itself . Once the Download is complete Restart the Visual Studio
Once you restart Visual Studio , the installation of these will start happening and you will get the below window.
Click on Modify and the installation will start. It takes some time , so please be patient. Once the installation is complete , you will get the below confirmation