This is explained right at the start of the documentation:
SSDT for Visual Studio 2019
Changes in SSDT for Visual Studio 2019
The core SSDT functionality to create database projects has remained integral to Visual Studio.
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.
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.
- For Analysis Services, Integration Services, or Reporting Services projects, you can install the appropriate extensions from either Tools > > Extensions and Updates or from the Marketplace.
- Analysis Services
- Integration Services
- Reporting Services
Once your installed the needed extension, create the appropriate project type, and then you can start making the appropriate files in that project.
Answer from Thom A on Stack OverflowVideos
This is explained right at the start of the documentation:
SSDT for Visual Studio 2019
Changes in SSDT for Visual Studio 2019
The core SSDT functionality to create database projects has remained integral to Visual Studio.
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.
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.
- For Analysis Services, Integration Services, or Reporting Services projects, you can install the appropriate extensions from either Tools > > Extensions and Updates or from the Marketplace.
- Analysis Services
- Integration Services
- Reporting Services
Once your installed the needed extension, create the appropriate project type, and then you can start making the appropriate files in that project.
Select new project/"clear all" the filters/type "integration" in search - and then the miracle "Integration services projects" appear from the 3x10e172 different alternatives..
Used to be under "business intelligence"--that's gone, categories not required when google does your thinking.
Hi @user ,
There no more SSDT for VS2019 SSIS projects.
You need to download, and install SQL Server Integration Services Projects extension for VS2019 SSIS projects.
Here is its download link: SQL Server Integration Services Projects
IMPORTANT: Please download v.3.16, and ignore any 4.* versions.
Hi @user ,
Create a blank solution
Extensions ... Manage Extensions
Online ... Visual Studio Marketplace
SQL Server Integration Services Projects
Download and install
Please note that VS2019 removed the business intelligence catalog, you may need to search for integration to create SSIS project.
Regards，
Zoe Hui
If the answer is helpful, please click "Accept Answer" and upvote it.
I am using the MS Hosted runner image as base then adding some additional toolsets that we need. The SSIS projects is not an available workload for the packer build to include natively, I have to install it after. The issue I have is I don't want to be dependent on a single version, but would prefer to download the latest:
https://marketplace.visualstudio.com/_apis/public/gallery/publishers/SSIS/vsextensions/MicrosoftDataToolsIntegrationServices/1.3.2/vspackage
The current version seems to be 1.3.2. For the other toolsets I have added extra, I am able to find them in some package manager, repository or GitHub to grab. I cannot seem to find a way with this one. I was thinking of using vswhere.exe to get the version of VS that the system has and use that as a basis of what version to get of the SSIS projects extension.
Updated:
I reviewed their older releases:
https://ssis.gallerycdn.vsassets.io/extensions/ssis/microsoftdatatoolsintegrationservices/1.0.1/1687243002634/Microsoft.DataTools.IntegrationServices.exe
I see that, that is a blob. I cannot move up to a more higher-level:
https://ssis.gallerycdn.vsassets.io/extensions/ssis/microsoftdatatoolsintegrationservices
I get a:
<Error> <Code>BlobNotFound</Code>
<Message>The specified blob does not exist. RequestId:78e28227-c01e-004d-159f-2306f5000000 Time:2023-11-30T15:11:47.2421681Z</Message> </Error>
which makes sense since it is a container path, not the blob itself, but even in storage explorer, connecting to:
https://ssis.gallerycdn.vsassets.io/extensions
Results in a cert error, then when I switched to use the system proxy, it gets an auth error, but being that this is a public blob, I assume it is using anonymous auth at the container level.
Hi @Greg Booth ,
For SSIS development you would need the following:
- VS2019 v.16.11.* any edition, including Community edition.
- SQL Server Integration Services Projects extension for VS2019.
v.3.16, and stay away from any 4. version of it. These versions are experimental, buggy, and missing some features.
A collegue recently tried doing this, and found that they could create packages, but not edit the scripts.
SSIS Script Taks is using another sub-component: Microsoft Visual Studio Tools for Applications 2019.
You could go the Control Panel, Program and Features, find it there, right mouse click and select Repair it.
Thanks very much!