SSIS Packages and SQL server agent job mIgration


Hi Experts,

Happy Thursday!

I need a bit of guidance on SSIS packages & SQL server JOB migration. We recently upgraded our SQL SERVER instance to 2019. What would be the best approach to migrate SSIS packages and SQL server agent jobs to the new instance?

I would appreciate your comments.

Look forward to your reply!


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

1 additional answer

Sort by: Most helpful
  1. ZoeHui-MSFT 33,386 Reputation points

    Hi @Anonymous ,

    Like AveryTang-7680 said, to migrate SQL Server agent job, it is more suitable to use transfer-jobs-task in SSIS.


    Zoe Hui

    If the answer is helpful, please click "Accept Answer" and upvote it.

    0 comments No comments