Share via

ssis jobs migrataion

k muthus 41 Reputation points
2022-03-08T05:32:25.85+00:00

We need to migrate job SSIS job 50 from one server to the other .
Is there way to do it . (like creating script)
is there a way to fix it .

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,153 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,612 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. ZoeHui-MSFT 38,621 Reputation points
    2022-03-08T07:29:22.47+00:00

    Hi @k muthus ,

    You may use Transfer Jobs Task to do that.

    The Transfer Jobs task transfers one or more SQL Server Agent jobs between instances of SQL Server.

    The Transfer Jobs task can be configured to transfer all jobs, or only specified jobs. You can also indicate whether the transferred jobs are enabled at the destination.

    transfer-jobs-task

    transfer-sql-server-jobs-task-and-transfer-sql-server-logins-task-in-ssis

    Regards，

    Zoe

    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    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.

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.