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
Public class 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.
Public class 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
Public interface ITransferStoredProceduresTask Infrastructure.

Enumerations

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