What's the best way to create and upgrade SSIS package to SQL 2019?

Michelle C 20 Reputation points
2023-08-30T05:20:53.2966667+00:00

Hi, What's the best way to create (and upgrade to) SSIS package in SQL 2019? Is it through Visual Studio 2019 or we can use a separate tool for this now? What's the most comprehensive method as with Visual Studio 2019 there seems to be different components one needs to add eg SSDT and BIDS or SSIS Projects extension?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
10,943 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,230 questions
0 comments
Accepted answer
  1. ZoeHui-MSFT 25,451 Reputation points
    2023-08-30T06:27:04.8266667+00:00

    Hi @Michelle C,

    You can use various methods to upgrade SQL Server 2008 (10.0.x), SQL Server 2008 R2 (10.50.x), SQL Server 2012 (11.x), or SQL Server 2014 (12.x) packages. For some of these methods, the upgrade is only temporary. For others, the upgrade is permanent. The following table describes each of these methods and whether the upgrade is temporary or permanent.

    User's image

    SQL Server provides the SSIS Package Upgrade Wizard to help in this process. Because you can configure the wizard to backup up your original packages, you can continue to use the original packages if you experience upgrade difficulties.

    The SSIS Package Upgrade Wizard is installed when Integration Services is installed.

    Check it out here: Upgrade Integration Services Packages Using the SSIS Package Upgrade Wizard

    Regards，

    Zoe Hui

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

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest