SSIS Projects extension for Visual Studio 2022+ troubleshooting guide

Applies to: SQL Server Azure SQL Database Azure Synapse Analytics

Visit the SQL Server Integration Services (SSIS) Blog 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

• To design packages using Oracle and Teradata connectors and target an earlier version of SQL Server before SQL Server 2019 (15.x), in addition to the Microsoft Oracle Connector and Microsoft Teradata Connector, you also need to install the corresponding version of Microsoft Connector for Oracle and Teradata by Attunity.

  • Microsoft Connector Version 5.0 for Oracle and Teradata by Attunity targeting SQL Server 2017
  • Microsoft Connector Version 4.0 for Oracle and Teradata by Attunity targeting SQL Server 2016
  • Microsoft Connector Version 3.0 for Oracle and Teradata by Attunity targeting SQL Server 2014
  • Microsoft Connector Version 2.0 for Oracle and Teradata by Attunity targeting SQL Server 2012

• Since version 3.3, Power Query Source for SQL Server 2017-2022 is excluded from the installation of this product. To continue using this component, manually download and install them by yourselves. Here are the download links: Power Query Source for SQL Server 2017-2022

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 Visual Studio instance upgrade. If your existing SSIS projects can't be loaded, try to repair this product via Control Panel. If Visual Studio doesn't pop up when selecting 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 Visual Studio 2022 17.4 and previous versions. 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:

  • Microsoft ODBC Driver for SQL Server
  • Microsoft OLE DB Driver for SQL Server

  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 isn't found after upgrading SSDT, make sure that the connector for latest SQL Server version is installed.

Known issues

1. In the context menu (right mouse button) on objects in the project (for example, the solution, a package) in Visual Studio, many of the entries appear many times.
2. Sometimes when you repair or update Visual Studio, the SSIS extension might be uninstalled. Reinstall it again.
3. If SSIS installed successfully, but the Solution Explorer shows incompatible, or The application is not installed:
   1. Open Visual Studio and navigate to Extension > Manage Extensions > Installed
   2. Enable SSIS extension
   3. Relaunch Visual Studio

For more information, see the Release notes.

Installation issues

The installation log file, Microsoft.DataTools.IntegrationServices_{Timestamp}_ISVsix.log, is located under the %temp%\SsdtisSetup folder. Check the error messages in the log file and follow these troubleshooting steps:

1. Pre-check verification AnotherInstallationRunning failure

   • If the log file contains keywords: Pre-check verification failed with warning(s): AnotherInstallationRunning, keep waiting and retry.
   • This error occurs because Windows Installer blocks your installation. Windows Installer is a subservice of Windows that manages the installation of packages like MSIs, Windows Update, or a third-party component, and it can only handle one thing at a time.

2. Other errors

   • Download VSInstallationTroubleShooting.ps1 and run it on your machine to help with 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 the /? argument to get more details of the arguments list of the installer.

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