Microsoft.SqlServer.Dts.Tasks.TransferJobsTask Namespace

The Microsoft.SqlServer.Dts.Tasks.TransferJobsTask namespace contains the classes and enumerations that allow you to copy SQL Server Agent jobs from one instance of SQL Server to another.

Classes

  Class Description
Public class TransferJobsTask Provides the methods and properties to transfer SQL Server Agent jobs from one instance of SQL Server to another.
Public class TransferJobsTask.DtsTransferJobsException The exception that is thrown at load time if the persisted name of the XML root node of the task is corrupt.

Interfaces

  Interface Description
Public interface ITransferJobsTask Infrastructure.

Enumerations

  Enumeration Description
Public enumeration IfObjectExists Contains values used by the IfObjectExists property of the TransferJobsTask to determine how to handle a transfer when the job exists at the destination.