This project may be used for building high performance data integration and workflow solutions, including extraction, transformation, and loading (ETL) operations for data warehousing.

Visit https://techcommunity.microsoft.com/t5/SQL-Server-Integration-Services/bg-p/SSIS for the latest information, tips, news, and announcements about SSIS directly from the product team.

Common issues, known issue and Offline installation guide are moved to SSIS in VS2022 troubleshooting guide.

Release Notes

Version 1.5

• Release Date: Sep 13, 2024
• Build Version: 16.0.5685.0
• Tested against Visual Studio 2022 17.11
• What's new: 1. Support Dimension Processing and Partitioning Processing components in SSIS
• Bug fix:
  1. SQLClient Data Provider for ADO.Net test connection error resolved. (Upgrade VS version to VS2022 17.12 preview 2)
  2. Fix the Internal error when Connect to Azure AS by Analysis Services Connection manager.
• Known issue:
  1. 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.
  2. DQS has side-by-side issue when target SQL Server Version is 2017 and 2019 when SQL Server engine installed at the same machine.

Version 1.4

• Release Date: Apr 28, 2024
• Download SQL Server Integration Services Projects 2022 1.3.2
• Build Version: 16.0.5556.0
• Tested against Visual Studio 2022 17.9
• Bug fix:
  1. Fix the bug "Specified Cast isn't valid while creating a SQL Server entry or reuse an existing SQL Server entry" when Convert to Project Deployment Model
  2. SQL Server Compact Edition Connection Manager and SQL Server Compact Edition Destination are removed from VS2022, as Microsoft SQL Sever Compact is end of life. Details refer to Microsoft SQL Server Compact Lifecycle
• Known issue:
  1. Dimension Processing and Partition Processing components are not supported.
  2. 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.
  3. DQS has side-by-side issue when target SQL Server Version engine installed at the same machine.

Version 1.3.2

• Release Date: Nov 28, 2023
• Download SQL Server Integration Services Projects 2022 1.3.2
• Build Version: 16.0.5397.1
• Tested against Visual Studio 2022 17.8
• Bug fix:
  1. ISDeployment wizard now supports Microsoft Entra Interactive Authentication.
  2. Run64BitRuntime false selection is disabled. From Visual Studio 2022, only 64-bit SSIS runtime is supported.
  3. DQS related components are supported.
• Known issue:
  1. Dimension Processing and Partition Processing components are not supported.
  2. 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.
  3. DQS has side-by-side issue when target SQL Server Version engine installed at the same machine.

Version 1.2

• Release Date: Sep 12, 2023
• Download SQL Server Integration Services Projects 2022 1.2
• Build Version: 16.0.5314.0
• Tested against Visual Studio 2022 17.6
• What's new:
  1. SQL server 2016 is supported as target server version.
• Bug fix:
  1. Project name in Solution Explorer UI shows target server version as suffix.
• Known issue:
  1. DQS related components are not supported.
  2. 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.
  3. Dimension Processing and Partition Processing components are not supported.

Version 1.1

• Release Date: Jul 20, 2023
• Download SQL Server Integration Services Projects 2022 1.1
• Build Version: 16.0.5228.0
• Tested against Visual Studio 2022 17.6
• Bug fix:
  1. When target server version is SQL Server 2017, some data flow components and control flow components cannot be opened.
• Known issue:
  1. SQL server 2016 is not supported as target server version. (Target server version supported are SQL server 2017, 2019 and 2022.)
  2. 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.
  3. Project name in Solution Explorer UI doesn’t show target server version as suffix.
  4. Dimension Processing and Partition Processing components are not supported.
  5. DQS related components are not supported.

Version 1.0

• Release Date: Jun 5, 2023
• Download SQL Server Integration Services Projects 2022 1.0
• Build Version: 16.0.5223.0
• Tested against Visual Studio 2022 17.6
• General Availability (GA) release
• Known issue:
  1. SQL server 2016 is not supported as target server version. (Target server version supported are SQL server 2017, 2019 and 2022.)
  2. 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.
  3. Project name in Solution Explorer UI doesn’t show target server version as suffix.
  4. Dimension Processing and Partition Processing components are not supported.
  5. DQS related components are not supported.
  6. Due to a limitation of VS marketplace, the version 1.0.1 just updates to remove preview tag, and does not introduce new binaries to download. Version 1.0 contains the latest binaries.

Version 0.4

• Release Date: Apr 21, 2023
• Download SQL Server Integration Services Projects 2022 0.4
• Build Version: 16.0.5209.0
• Tested against Visual Studio 2022 17.5
• Bug fix:
  1. Localization and globalization are now supported.
  2. Fix Execute SQL Task edit throw does not register issue.
• Known issue:
  1. Cannot design Dimension Processing and Partition Processing.
  2. Cannot design DQS related component.
  3. Project name in Solution Explorer UI doesn’t show target server version as suffix.

Version 0.3

• Release Date: Feb 14, 2023
• Download SQL Server Integration Services Projects 2022 0.3
• Build Version: 16.0.5131.0
• Tested against Visual Studio 2022 17.4 and 17.5 preview
• What's new:
  1. Target server version supported: SQL server 2017, 2019 and 2022.
  2. Azure-Enabled SSIS projects are now supported.
  3. Script Tasks/Component targeting SQL Server 2017 are upgraded to NET Framework 4.7.
  4. 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:
  1. VSIX install confirmation box in SSIS install and repair are removed.
  2. Logging page UI can't select package bug fix.
• Known issue:
  1. Cannot design Dimension Processing and Partition Processing.
  2. Cannot design DQS related component.
  3. Project name in Solution Explorer UI doesn’t show target server version as suffix.
  4. Localization and globalization are not supported.
  5. Oracle Connection Manager execute failed with error code 0x80004005 when targeting SQL Server 2017.

Version 0.2

• Release Date: Dec 6, 2022
• Download SQL Server Integration Services Projects 2022 0.2
• Build Version: 16.0.5035.3
• Tested against Visual Studio 2022 17.4
• Bug fix:
  1. Fix right click SSIS Packages and select wizards throw error.
• Known issue:
  1. Target sever version supported: SQL server 2019 and SQL server 2022
  2. Cannot design Dimension Processing and Partition Processing.
  3. Cannot design DQS related component.
  4. Project name in Solution Explorer UI doesn’t show target server version as suffix.
  5. Side by side, localization and globalization are not supported.
  6. Azure-enabled SSIS projects are not supported
  7. Repair command does not work. Please reinstall it instead.

Version 0.1

• Release Date: Nov 24, 2022
• Download SQL Server Integration Services Projects 2022 0.1
• Build Version: 16.0.5035.0
• Tested against Visual Studio 2022 17.4
• What’s new:
  1. Support SSIS in VS2022
• Known issue:
  1. Target sever version supported: SQL server 2019 and SQL server 2022
  2. Cannot design Dimension Processing and Partition Processing.
  3. Cannot design DQS related component.
  4. Project name in Solution Explorer UI doesn’t show target server version as suffix.
  5. Side by side, localization and globalization are not supported.
  6. To design packages using Oracle and Teradata connectors is not supported yet.
  7. Azure-enabled SSIS projects are not supported