Please follow the below steps to install this product in an offline environment:įollow this document to create an offline installation of Visual Studio, and make sure following prerequisites are included: SQL Server Integration Services Projects extension doesn't support Visual Studio 2022 yet.
If you want to continue using SQL Server Native Client, you can download and install it from here.
We recommend upgrading to the new Microsoft OLE DB driver for SQL Server. SQL Server Native Client (SQLNCLI11.1) is deprecated and not installed by VS2019. If VS doesn't pop up when clicking on "Edit Script", please try to repair VSTA 2019 via control panel. If your existing SSIS projects cannot be loaded, please try to repair this product via control panel. Sometimes this product or Visual Studio Tools for Applications 2019 may be somehow deleted during VS instance upgrade.
To design packages using Oracle and Teradata connectors and targeting an earlier version of SQL server prior to SQL 2019, in addition to the Microsoft Oracle Connector for SQL 2019 and Microsoft Teradata Connector for SQL 2019, you need to also install the corresponding version of Microsoft Connector for Oracle and Teradata by Attunity.
Please upgrade to 3.13.1 to bypass those issues. There is a regression in SSIS Projects extension 3.13 that cannot rename a task/data flow component on design surface and cannot add annotation.
Currently the supported target server version starts from SQL Server 2012 up to 2019. This project may be used for building high performance data integration and workflow solutions, including extraction, transformation, and loading (ETL) operations for data warehousing.