Working with SSIS packages in Visual Studio

To be able to create, edit, and test MSSQL SSIS package solutions in Visual Studio Community edition we need to install the SQL Server Data Tools under Data storage and processing in the list of workloads.

  • Start the Visual Studio Installer from the Windows Start Menu,
  • Select the installed Visual Studio instance you want to update,
  • In the Web and Cloud section select the Data storage and processing panel,
  • On the right side check SQL Server Data Tools

  • At the bottom of the page click the Modify button.

Creating SQL Server Integration Services (SSIS) projects

SSIS extensions at Install SQL Server Data Tools (SSDT) for Visual Studio

See Integration Services (SSIS) Projects and Solutions for more information

Leave a comment

Your email address will not be published. Required fields are marked *