Microsoft.SqlServer.Dts.Tasks.TransferStoredProceduresTask Namespace

The Microsoft.SqlServer.Dts.Tasks.TransferStoredProceduresTask namespace contains the methods, properties, and enumerations that allow you to copy stored procedures from the master database located on one instance of SQL Server to another.

Classes

TransferStoredProceduresTask

Contains the methods, properties, and enumerations that allow you to copy stored procedures from the master database located on one instance of SQL Server to another. This class cannot be inherited.

TransferStoredProceduresTask.DtsTransferSPException

The exception that is thrown at load time if the persisted name of the XML root node of the task is corrupt.

Interfaces

ITransferStoredProceduresTask

Represents a Transfer Stored Procedures task.

Enums

IfObjectExists

Contains values used by the IfObjectExists property of the TransferStoredProceduresTask to determine how to handle a transfer when the stored procedure exists at the destination.