...

Prerequisites for ssdt что это за программа и нужна ли она

SSIS Projects extension for VS2019 troubleshooting guide

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

  • To design packages using Oracle and Teradata connectors and targeting an earlier version of SQL Server prior to SQL Server 2019, in addition to the Microsoft Oracle Connector and Microsoft Teradata Connector, you need to also 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

    Common issues

    • SSIS Execute Package Task doesn’t support debugging when ExecuteOutOfProcess is set to True.
    • This extension doesn’t support Visual Studio 2022. Please use SQL Server Integration Services Projects extension 2022.
    • Sometimes this product or Visual Studio Tools for Applications 2019 may 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 clicking on «Edit Script», try to repair VSTA 2019 via control panel. We’ve reported this issue to VS team. Sorry for any inconvenience.
    • The SQL Server Native Client (often abbreviated SNAC) has been removed from SQL Server 2022 (16.x) and SQL Server Management Studio 19 (SSMS). The SQL Server Native Client (SQLNCLI or SQLNCLI11) and the legacy Microsoft OLE DB Provider for SQL Server (SQLOLEDB) are not recommended for new application development. Switch to the new Microsoft OLE DB Driver (MSOLEDBSQL) for SQL Server or the latest Microsoft ODBC Driver for SQL Server going forward. For SQLNCLI that ships as a component of SQL Server Database Engine (versions 2012 through 2019), see this Support Lifecycle exception.

    Known issues

    Version 4.1

    • Known issues:
      1. Due to a limitation of VS marketplace, the version 4.1.2 does not introduce new binaries to download. Version 4.1 contains the latest binaries.

    Version 4.0 preview:

    • Known issues:
      1. CDC source component in target SQL Server 2022 (16.x) can’t do preview.
      2. When executing SSIS project targeting SqlServer 2019 on the environment that SQL Server 2019 are also installed, the execution will fail with error «Unable to cast COM object of type System._ComObject to interface type Microsoft.SqlServer.Dts.Runtime.Wrapper.Sql2019.IDTSApplication160». Workaround: Solution Explorer -> right-click project ->properties->debugging->Run64bitRuntime->set to false.

    Installation issues

    If you install successfully, but the solution shows «incompatible», and «The application isn’t installed»:

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

    If you get an error during installation, and find «Bundle action failed: Invalid pointer (0x80004003)» in the log. You can check the logs under %temp%\SsdtisSetup, the more detail log is under Microsoft.DataTools.IntegrationServices__ISVsix.log:

      When the error is «The file already exists.»: 
     cd C:\Program Files (x86)\Microsoft Visual Studio\2019\Community\Common7\IDE rm CommonExtensions\Microsoft\SSIS\* rm PublicAssemblies\SSIS\* rm "PublicAssemblies\Microsoft BI\Business Intelligence Projects\Integration Services\"*
    • delete the broken instance folder «%ProgramData%\Microsoft\VisualStudio\Packages_Instances»
    • delete C:\ProgramData\Package Cache\15160B731819F56D87A626F9A2777550340022D7 and retry.

    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 Version=»[16.0,)» DisplayName=»C# and Visual Basic»
      • Prerequisite Version=»[16.0,)» DisplayName=»Visual Studio core editor»
      • Prerequisite Version=»[16.0,)» DisplayName=»SQL Server Data Tools»
      • Prerequisite Version=»[16.0,)» DisplayName=».NET Framework 4 targeting pack»
      • Prerequisite Version=»[16.0,)» DisplayName=».NET Framework 4.5 targeting pack»
      • Prerequisite Version=»[16.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 does not 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 a totally offline environment, we recommend you to install this product on VS Professional or Enterprise, which support offline activation via a product key.

    SSIS Projects extension for VS2019 troubleshooting guide

    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

    • To design packages using Oracle and Teradata connectors and targeting an earlier version of SQL Server prior to SQL Server 2019, in addition to the Microsoft Oracle Connector and Microsoft Teradata Connector, you need to also 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

      Common issues

      • SSIS Execute Package Task doesn’t support debugging when ExecuteOutOfProcess is set to True.
      • This extension doesn’t support Visual Studio 2022. Please use SQL Server Integration Services Projects extension 2022.
      • Sometimes this product or Visual Studio Tools for Applications 2019 may 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 clicking on «Edit Script», try to repair VSTA 2019 via control panel. We’ve reported this issue to VS team. Sorry for any inconvenience.
      • The SQL Server Native Client (often abbreviated SNAC) has been removed from SQL Server 2022 (16.x) and SQL Server Management Studio 19 (SSMS). The SQL Server Native Client (SQLNCLI or SQLNCLI11) and the legacy Microsoft OLE DB Provider for SQL Server (SQLOLEDB) are not recommended for new application development. Switch to the new Microsoft OLE DB Driver (MSOLEDBSQL) for SQL Server or the latest Microsoft ODBC Driver for SQL Server going forward. For SQLNCLI that ships as a component of SQL Server Database Engine (versions 2012 through 2019), see this Support Lifecycle exception.

      Known issues

      Version 4.1

      • Known issues:
        1. Due to a limitation of VS marketplace, the version 4.1.2 does not introduce new binaries to download. Version 4.1 contains the latest binaries.

      Version 4.0 preview:

      • Known issues:
        1. CDC source component in target SQL Server 2022 (16.x) can’t do preview.
        2. When executing SSIS project targeting SqlServer 2019 on the environment that SQL Server 2019 are also installed, the execution will fail with error «Unable to cast COM object of type System._ComObject to interface type Microsoft.SqlServer.Dts.Runtime.Wrapper.Sql2019.IDTSApplication160». Workaround: Solution Explorer -> right-click project ->properties->debugging->Run64bitRuntime->set to false.

      Installation issues

      If you install successfully, but the solution shows «incompatible», and «The application isn’t installed»:

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

      If you get an error during installation, and find «Bundle action failed: Invalid pointer (0x80004003)» in the log. You can check the logs under %temp%\SsdtisSetup, the more detail log is under Microsoft.DataTools.IntegrationServices__ISVsix.log:

        When the error is «The file already exists.»: 
       cd C:\Program Files (x86)\Microsoft Visual Studio\2019\Community\Common7\IDE rm CommonExtensions\Microsoft\SSIS\* rm PublicAssemblies\SSIS\* rm "PublicAssemblies\Microsoft BI\Business Intelligence Projects\Integration Services\"*
      • delete the broken instance folder «%ProgramData%\Microsoft\VisualStudio\Packages_Instances»
      • delete C:\ProgramData\Package Cache\15160B731819F56D87A626F9A2777550340022D7 and retry.

      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 Version=»[16.0,)» DisplayName=»C# and Visual Basic»
        • Prerequisite Version=»[16.0,)» DisplayName=»Visual Studio core editor»
        • Prerequisite Version=»[16.0,)» DisplayName=»SQL Server Data Tools»
        • Prerequisite Version=»[16.0,)» DisplayName=».NET Framework 4 targeting pack»
        • Prerequisite Version=»[16.0,)» DisplayName=».NET Framework 4.5 targeting pack»
        • Prerequisite Version=»[16.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 does not 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 a totally offline environment, we recommend you to install this product on VS Professional or Enterprise, which support offline activation via a product key.

      При подготовке материала использовались источники:
      https://learn.microsoft.com/en-us/sql/ssdt/release-notes-ssdt-2019?view=sql-server-ver16&source=recommendations
      https://learn.microsoft.com/en-gb/sql/ssdt/release-notes-ssdt-2019?view=sql-server-ver15

Оцените статью
© 2025 Проверка скорости интернета. Все права защищены. Мы не имеем никакого отношения к сервису speedtest.net. Мы отдельный и самостоятельный сервис проверки скорости интернета
Обратная связь Политика конфиденциальности