SQL Server 2019 + Visual Studio Recomendation for SSIS

Divyesh Patel 16 Reputation points
2021-09-30T16:39:21.723+00:00

Hi,

We are in process of upgrading to SQL Server 2019 from SQL Server 2016 . All our packages are built using SQL Server Data Tools 14.0.61712.050 with target server 2016. When we upgrade to 2019 we would also like to upgrade to latest version of SSIS Designer . With SQL Server 2019 should we use VS2019 and download the SSIS Extension ? What version of Visual Studio is recommended to use ? I could not find any recommendations .

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,264 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,508 questions
VB
VB
An object-oriented programming language developed by Microsoft that is implemented on the .NET Framework. Previously known as Visual Basic .NET.
2,652 questions
0 comments No comments
{count} votes

3 answers

Sort by: Most helpful
  1. Tom Phillips 17,721 Reputation points
    2021-09-30T17:06:36.237+00:00

    You should be using the most current version of Visual Studio with the most current version of the add-in.

    0 comments No comments

  2. ZoeHui-MSFT 34,996 Reputation points
    2021-10-01T01:25:15.447+00:00

    Hi @Divyesh Patel .

    You may use Visual Studio 2019 and the newest SQL Server Integration Services Projects v3.15.

    Reference: download-sql-server-data-tools-ssdt

    SQL Server Integration Services Projects

    Regards,

    Zoe


    If the answer is helpful, please click "Accept Answer" and upvote it.

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
    Hot issues October


  3. Olaf Helper 42,921 Reputation points
    2021-10-01T06:00:57.697+00:00

    What version of Visual Studio is recommended to use ?

    Visual Studio 2019 is the latest version, so what else to recommend?!

    0 comments No comments