Upgrade wizard error in SSIS package

Avyayah 1,291 Reputation points
2021-06-03T20:30:15.737+00:00

There are few packages in the database and upgrade Wizard has error, not sure where and how I can correct the hard coded configuration of the packages. Migrating SSIS packages from 2008R2 to 2016.
102119-ssispackage.jpg

102221-upgradewizarderror.jpg

SQL Server Integration Services
{count} votes

Answer accepted by question author
  1. ZoeHui-MSFT 41,536 Reputation points
    2021-06-04T01:40:12.587+00:00

    Hi @Avyayah ,

    You are upgrading Integration Services Packages Using the SSIS Package Upgrade Wizard.

    We'd suggest that you may carefully refer the official documentation step by step.

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

    ssis-package-upgrade-wizard-f1-help

    The error message is same as your original issue post here, you may check if the reply is useful.

    Also you here is the same issue when upgrading, you may take a carefully reference.

    https://www.sqlservercentral.com/forums/topic/migration-of-ssis-from-sql-2005-to-sql-2012

    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

    0 comments No comments

0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.