![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(38.4, 17%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPE%3C/text%3E%3C/svg%3E)
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,460 questions
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.