How do you create an SSIS package with SQL Server 2019/Visual Studio 2019? I don't see any BI options for SSIS, SSRS, or SSAS when creating a new project in Visual Studio. I have the free SQL Server 2019 Developer edition installed. I also have the Community Visual Studio 2019 free version installed. I installed SSDT with Visual Studio 2019. I selected SQL Server Data Tools under Data storage and processing in the list of workloads. On the Windows Start menu, I searched for Visual Studio (SSDT) but I it doesn't look like Visual Studio (SSDT) is installed. I tried uninstalling and re-installing SSDT with Visual Studio Installer (SQL Server Data Tools under Data storage and processing in the list of workloads). I also installed SSIS in Visual Studio 2019 under Extensions/Manage Extensions.
CeeBeeBee :
Select new project/"clear all" the filters/type "integration" in search - and then the miracle "Integration services projects" appear from the 3x10e172 different alternatives..\nUsed to be under "business intelligence"--that's gone, categories not required when google does your thinking.",
2021-02-10T09:49:12