question

ParashuramaEshwarappa-7484 avatar image
0 Votes"
ParashuramaEshwarappa-7484 asked CarrinWu-MSFT commented

SSIS 2012 PACKAGE RUNNING ON SQL SERVER 2019

We are having the SSIS package developed with version SSIS 2012.
If the SQL server is upgraded to the SQL SERVER 2019 then will the old version of the SSIS package run without any issue?

sql-server-integration-services
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @ParashuramaEshwarappa-7484, we have not get a reply from you. Could below answers help you? If yes, please do "Accept Answer". By doing so, it will benefit for community members who have this similar issue. Your contribution is highly appreciated. Thank you!

0 Votes 0 ·

1 Answer

CarrinWu-MSFT avatar image
0 Votes"
CarrinWu-MSFT answered CarrinWu-MSFT edited

Hi @ParashuramaEshwarappa-7484,

Welcome to Microsoft Q&A!

If the SQL server is upgraded to the SQL SERVER 2019 then will the old version of the SSIS package run without any issue?

It will depends on your environment and how to upgrade SQL Server. When you upgrade an instance of SQL Server 2008 to the current release of SQL Server, your existing SQL Server 2012 Integration Services (SSIS) packages are not automatically upgraded to the package format that the current release SQL ServerIntegration Services uses. You will have to select an upgrade method and manually upgrade your packages. If you would like to upgrade Integration Services and SSIS package, we recommended that you run Upgrade Advisor before you upgrade to SQL Server 2019 (15.x). Upgrade Advisor reports issues that you might encounter if you migrate existing Integration Services packages to the new package format that SQL Server 2019 (15.x) uses. In addition, please remember to back up your databases and packages before the upgrade.

For more information, please refer to below links:
Upgrade Integration Services
Upgrade Integration Services Packages Using the SSIS Package Upgrade Wizard
Upgrade Integration Services Packages
Upgrade and Migrate SSIS Catalog and SSISDB to a New Server


Best regards,
Carrin


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.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.