Transfer Jobs Task
The Transfer Jobs task copies SQL Server Agent jobs from the source SQL Server instance to the destination SQL Server instance. This task uses the SMO Connection Manager to connect to the source and destination SQL Server instances. The task is quite straightforward to configure.
Following are the steps you will be performing to configure this task:
1. | Open the editor window for the task and specify the name and description in the General page. |
2. | You will specify most settings in the Jobs page. Specify a SourceConnection and DestinationConnection to connect to source and destination servers using the SMO Connection Manager in the Connections section. |
3. | In the Jobs area, you can specify to copy all the jobs to the destination ... |
Get Hands-On Microsoft SQL Server™ 2005 Integration Services now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
