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.3.2

• Release Date: Nov 28, 2023
• Build Version: 16.0.5397.1
• Tested against Visual Studio 2022 17.8
• Bug fix:
  1. Fixed a bug in 1.3.1 when create or edit a Flat File or File connection, it throws "The connection manager 'FLATFILE' is not properly installed on this computer. (Microsoft.DataTransformationServices.Design)"
• 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 related component is not supported in target SQL Server 2019.

Version 1.3.1

• Release Date: Nov 22, 2023
• Build Version: 16.0.5396.0
• Tested against Visual Studio 2022 17.8
• Bug fix:
  1. Fixed a bug in 1.3 that an unexpected error, 'Strong name validation failed (Exception from HRESULT: 0x8013141A),' appeared upon attempting to create an SSIS project,
  2. Fixed a bug in 1.3 the error 'The DataWarehouse VSIntegration layer package did not load correctly' appeared upon attempting to open an existing SSIS project.
• 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.

Version 1.3

• Release Date: Nov 21, 2023
• Build Version: 16.0.5395.0
• Tested against Visual Studio 2022 17.8
• What's new:
  1. ISDeployment wizard now supports Microsoft Entra Interactive Authentication.
  2. DQS related components are supported.
  3. Run64BitRuntime false selection is disabled. From Visual Studio 2022, only 64-bit SSIS runtime is supported.
  4. 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
• Bug fix:
  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. Added notification to "Repair Microsoft Visual Studio Tools for Applications 2022 via Control Panel" when hit the issue of “Editing script but nothing happened”.
  3. ODBC Source Editor preview does not work when entering text in “Name of the table or the view” box.
• Known issue:
  1. Dimension Processing and Partition Processing components are not supported.

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