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

Question

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

Michelle C 20

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?

Accepted answer

0 additional answers

Your answer

Answer 1

ZoeHui-MSFT 41,491

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.

Michelle C 20 Reputation points

2023-08-30T08:05:31.1933333+00:00

The upgrade is working now. Thanks much for your input.
Michelle C 20 Reputation points

2023-08-30T08:09:20.6066667+00:00

What's the best way to create a new BI solution in Visual Studio? Do I need a separate extension or workload to be able to do that?
ZoeHui-MSFT 41,491 Reputation points

2023-08-30T08:26:04.2733333+00:00

Hi @Michelle C,

create a new BI solution in Visual Studio

Suppose that you want to create SSIS packages or SSRS reports.

For Analysis Services, Integration Services, or Reporting Services projects, you can install the appropriate extensions from within Visual Studio with Extensions > Manage Extensions or from the Marketplacein VS2022.

For other versions, please check here.

If this helps on your issue, you could mark it as answer so other user with similar problem could see this easier. :)

Share via

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

0 additional answers

Your answer