This project may be used for building high performance data integration and workflow solutions, including extraction, transformation, and loading (ETL) operations for data warehousing.
This project may be used for building high performance data integration and workflow solutions, including extraction, transformation, and loading (ETL) operations for data warehousing.
SQL server 2016 is not supported as target server version. (Target server version supported are SQL server 2017, 2019 and 2022.)
In the context menu (right mouse button) on objects in the project (e.g. the solution, a package) in Visual Studio, many of the entries appear many times. This happens only when Microsoft Analysis Services Projects 2022 is installed together.
Project name in Solution Explorer UI doesn’t show target server version as suffix.
Dimension Processing and Partition Processing components are not supported.
Tested against Visual Studio 2022 17.4 and 17.5 preview
What's new:
Target server version supported: SQL server 2017, 2019 and 2022.
Azure-Enabled SSIS projects are now supported.
Script Tasks/Component targeting SQL Server 2017 are upgraded to NET Framework 4.7.
SQL Server Analysis Services and SQL Server Reporting Services extensions can now work side-by-side with this extension (Test based on VS2022 17.5 preview 4).
Bug fix:
VSIX install confirmation box in SSIS install and repair are removed.
Logging page UI can't select package bug fix.
Known issue:
Cannot design Dimension Processing and Partition Processing.
Cannot design DQS related component.
Project name in Solution Explorer UI doesn’t show target server version as suffix.
Localization and globalization are not supported.
Oracle Connection Manager execute failed with error code 0x80004005 when targeting SQL Server 2017.