sql - Building SSIS Packages in Visual Studio

Question

I think this is about as basic question as I can have, but what version of Microsoft Visual Studio and what packages do I need to install in order to create SSIS Packages that I can install in SQL Server to run in scheduled jobs? I have done this before, but now whenever I download Visual Studio my toolbox is empty and I cant seem to find any of my data flow tasks no matter what I install. Any help would be much appreciated as this basic task has me a bit frustrated.

Answer 1

For VS2017 and earlier versions, you can easily find it after creating an SSIS project.

In a solution where includes SSIS project:

For VS2019, as this document states the required functionality to enable Analysis Services, Integration Services, and Reporting Services projects has moved into the respective Visual Studio extensions.

To find SSIS Toolbox in your VS2019:

1. Download the extension for SSIS here

2. Create a new SSIS project and you can find the ToolBox