Update 19 Sep 2022: I communicated with the Microsoft SSIS Team. They shared they are targeting preview of VS2022 Integration Services Extension for the end of CY22.

Important Note: I have not yet tested this version of the Integrated Services Extension in Visual Studio 2022.

On 28 Jul 2021, the Microsoft SSIS Team released an update to version 4.1.2 of the Integration Services extension that includes support for Visual Studio 2022: SQL Server Integration Services Projects extension with support for Visual Studio 2022. An operative bullet for this version:

• This project may be used for building high performance data integration and workflow solutions, including extraction, transformation, and loading (ETL) operations for data warehousing. Currently the supported target server version starts from SQL Server 2012 up to 2022. (emphasis mine)

A couple notable bullets in this release’s Common Issues section:

Apologies for not catching this update earlier.

There are plenty of warnings and caveats listed in the SQL Server Integration Services Projects article. Please read it before updating.

Need Help with Your Enterprise ETL or Data Warehouse?

At Enterprise Data & Analytics, we believe you should ask four questions when hiring an enterprise data consultancy.

Enterprise Data & Analytics offers comprehensive ETL, SSIS, Data Warehouse, and Azure Data Factory knowledge, experience, and success to your enterprise. We engage in three phases:

1. Training – Enterprise Data & Analytics offers enterprise-scale, experience-based training; sharing knowledge from experience with enterprise teams of all sizes.
2. Partnering – Enterprise Data & Analytics team members join your enterprise team members at the developer, project manager, and developer manager levels to shepherd (freshly-trained) team members as we – together – apply data integration patterns to your enterprise data warehouse solution.
3. Sustaining – After the code is implemented, tested, documented, and signed-off; Enterprise Data & Analytics team members stand ready to support your enterprise data warehouse team in the event of a disaster, re-join your team to jumpstart the next version, or merely to answer a question.

Contact us today!