SSIS Package Migration from 2005 to 2019

Litty Kuriakose 106 Reputation points
2021-09-01T07:44:16.947+00:00

Can we upgrade SSIS 2005 packages to 2019 directly?
If possible what are the common issues faced?
If we need to migrate to an intermediate version ,which is the preferred intermediate version?

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,490 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. ZoeHui-MSFT 34,581 Reputation points
    2021-09-01T08:16:18.38+00:00

    Hi @Litty Kuriakose ,

    You may upgrade SSIS 2005 packages to 2019 using the SSIS Package Upgrade Wizard.

    Remember to back up the original packages so that you can continue to use them if you experience upgrade difficulties.

    Related article for your reference:

    upgrade-integration-services-packages-using-the-ssis-package-upgrade-wizard

    ssis-2005-to-2019

    Regards´╝î

    Zoe


    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.
    Hot issues October