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,703 questions
0 comments No comments
{count} votes

Accepted answer
  1. Avery Tang 161 Reputation points
    2022-08-12T01:36:03.38+00:00

    Hi @Anonymous ,

    You may refer to this article.

    https://www.sqlshack.com/moving-the-ssisdb-catalog-on-a-new-sql-server-instance/

    To migrate SQL Server agent job, transfer-jobs-task is a good choice to do that.

    1 person found this answer helpful.
    0 comments No comments

1 additional answer

Sort by: Most helpful
  1. ZoeHui-MSFT 41,491 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

Your answer

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