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.
12,870 questions
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 answer

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