Explore LABS

Follow

Adding Data Tools/Integration Services to Visual Studio 2019

 

With Visual Studio 2019, the required functionality to enable Analysis Services, Integration Services, and Reporting Services projects has moved into the respective Visual Studio (VSIX) extensions only. Integration Services is required in order to use the mSQL SSIS components.

 Note

There's no SSDT standalone installer for Visual Studio 2019.

 

Install SSDT with Visual Studio 2019

If Visual Studio 2019 is already installed, you can edit the list of workloads to include SSDT. If you don’t have Visual Studio 2019 installed, then you can download and install Visual Studio 2019 Community.

  • For SQL Database projects, select SQL Server Data Tools under Data storage and processing in the list of workloads.
    Data storage and processing workload

Then you must install the Integration Services Extension Separately after adding Data Tools

Integration Services

After installing the Integration Services Extension

Start Visual Studio 2019 you will get almost the similar screen below. Click Create a new project.


Click on Integration Services Project, Click Next.


Enter the Project name and Location. Click Create.

Was this article helpful?
0 out of 0 found this helpful

0 Comments

Article is closed for comments.