SSIS Packages and SQL server agent job mIgration

Prajapati, Jinal 21 Reputation points
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.
1,956 questions

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. ZoeHui-MSFT 20,101 Reputation points
    2022-08-16T03:21:58.34+00:00

    Hi @Prajapati, Jinal ,

    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.