What version of visual studio do we need to develop integration services projects ?

Question

We are going to be developing SSIS Solutions for SSIS (Sql server) 2019.
We will be using scripts ( c#) in the SSIS packages.
What version of visual studio do we need ?
Can we use Visual Studio Community edition and then add the SSIS extyension from the marketplace ? (from https://marketplace.visualstudio.com/items?itemName=SSIS.SqlServerIntegrationServicesProjects )

A collegue recently tried doing this, and found that they could create packages, but not edit the scripts.

We would like to avoid using the professional version of visual studio.

Answer 1

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.

Answer 2

Thanks very much!