SSIS Packages and SQL server agent job mIgration

Anonymous
2022-08-11T16:09:58.56+00:00

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!

Regards,
Jinal

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
    2022-08-16T03:21:58.34+00:00

    Hi @Anonymous ,

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

    Regards,

    Zoe Hui


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

    0 comments No comments