SSIS 2012 PACKAGE RUNNING ON SQL SERVER 2019

Parashurama Eshwarappa 1 Reputation point
2021-09-20T11:25:42.61+00:00

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
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,510 questions
{count} votes

1 answer

Sort by: Most helpful
  1. CarrinWu-MSFT 6,866 Reputation points
    2021-09-21T02:17:29.82+00:00

    Hi @Parashurama Eshwarappa ,

    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.

    0 comments No comments