SSIS Projects extension for VS2022 troubleshooting guide

  • Article

Applies to: SQL Server Azure SQL Database Azure Synapse Analytics

Important

You can download the SSIS from the Visual Studio Marketplace.

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. Integration Services (SSIS) extension release notes are listed on the extension marketplace.

Component Download

Common Issues

  • SSIS Execute Package Task doesn't support debugging when ExecuteOutOfProcess is set to True.

  • Third party components aren't supported yet.

  • Sometimes this product or Visual Studio Tools for Applications 2022 might be somehow deleted during VS instance upgrade. If your existing SSIS projects cannot be loaded, try to repair this product via control panel. If VS doesn't pop up when selecting on "Edit Script", try to repair VSTA 2022 via control panel.

  • SSDT side by side issue. SQL Server Analysis Services and SQL Server Reporting Services extensions can now work side-by-side with this extension in VS2022 17.4 and previous version. The workaround is to download Visual Studio 2022 17.5 Preview 2 or later.

  • SQL Server Native Client (SNAC) isn't shipped with:

    • SQL Server 2022 (16.x) and later versions
    • SQL Server Management Studio 19 and later versions

    The SQL Server Native Client (SQLNCLI or SQLNCLI11) and the legacy Microsoft OLE DB Provider for SQL Server (SQLOLEDB) aren't recommended for new application development.

    For new projects, use one of the following drivers:

    For SQLNCLI that ships as a component of SQL Server Database Engine (versions 2012 through 2019), see this Support Lifecycle exception.

  • If Oracle, Teradata, or other OOB component is not found after upgrading SSDT, make sure that the connector for latest SQL Server version is installed.

Known issues

More detail in Release Note.

Installation issues

If SSIS installed successfully, but the Solution Explorer shows "incompatible", or "The application isn't installed":

  1. Open Visual Studio -> Extension -> Manage Extensions -> Installed
  2. Enable SSIS extension
  3. Relaunch Visual Studio

If SSIS installation shows Setup Failed with "Unknown error(0x80131500)" or "ISVsix Unknown error", open %temp%\SsdtisSetup folder, search in Microsoft.DataTools.IntegrationServices_{latestTimestamp}_ISVsix.log:

  • The error is "Pre-check verification failed with warning(s): AnotherInstallationRunning.",

    1. Keep waiting and retry. More detail: Windows Installer block your installation. Windows Installer is a subservice of Windows that manages the installation of packages like MSIs, Windows Update or a 3rd party things, and it can only handle one thing at a time.

  • The error is "The file {filefullpath} already exists.":

    1. Run the following commands from an elevated command prompt:

      cd "C:\Program Files\Microsoft Visual Studio\2022\Professional\Common7\IDE\"
rm CommonExtensions\Microsoft\SSIS\*
rm PublicAssemblies\SSIS\*
rm "PublicAssemblies\Microsoft BI\Business Intelligence Projects\Integration Services\"*

    2. Repair the VS2022 via VS installer

    3. Restart PC and reinstall SSIS

  • The error is "Object reference not set to an instance of an object.",

    • delete the broken instance folder "%ProgramData%\Microsoft\VisualStudio\Packages_Instances<InstallationID>"

  • The error is "Error 0x80091007: Failed to verify hash of payload",

    • delete C:\ProgramData\Package Cache\15160B731819F56D87A626F9A2777550340022D7 and retry.

If your error isn't in the above list, you can zip %temp%\SsdtisSetup and send the logs to ssistoolsfeedbacks@microsoft.com for troubleshooting.

Offline installation

Follow the below steps to install this product in an offline environment:

  1. Refer to the instructions in Create an offline installation package of Visual Studio for local installation, and make sure the following prerequisites are included:

    • Prerequisite ID="Microsoft.VisualStudio.Component.Roslyn.LanguageServices" Version="[17.0,)" DisplayName="C# and Visual Basic"
    • Prerequisite ID="Microsoft.VisualStudio.Component.CoreEditor" Version="[17.0,)" DisplayName="Visual Studio core editor"
    • Prerequisite ID="Microsoft.Net.Component.4.7.TargetingPack" Version="[17.0,)" DisplayName=".NET Framework 4.7 targeting pack"

  2. Launch the installer of this product and perform the installation, or you can run the installer in quiet mode. Launch the installer with "/?" argument to get more details of the arguments list of the installer.

  3. VS Community doesn't support offline activation. To use this product with VS Community, you must log in to your Microsoft account occasionally in VS Community. If you want to use this product in an offline environment, we recommend you to install this product on VS Professional or Enterprise, which support offline activation via a product key.