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

Class Description
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

Interface Description
ITransferStoredProceduresTask  

Enumerations

Enumeration Description
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.