TransferStoredProceduresTask Members

  • Article

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.

The following tables list the members exposed by the TransferStoredProceduresTask type.

Public Constructors

  Name Description
TransferStoredProceduresTask Initializes a new instance of the TransferStoredProceduresTask class.

Top

Public Properties

  Name Description
ms215206.pubproperty(en-US,SQL.90).gif DebugMode Gets or sets a Boolean indicating whether a task should determine whether breakpoints are enabled.
ms215206.pubproperty(en-US,SQL.90).gif DestinationConnection Gets or sets a String containing the name of the SMO connection manager for the source/destination database.
ms215206.pubproperty(en-US,SQL.90).gif ExecutionValue Overridden. Returns an object containing a count of the number of stored procedures that were transferred.
ms215206.pubproperty(en-US,SQL.90).gif IfObjectExists Gets or sets a value from the IfObjectExists enumeration indicating if the task should fail, overwrite the existing stored procedure, or skip the transfer of the stored procedureif a stored procedurewith the same name exists at the destination.
ms215206.pubproperty(en-US,SQL.90).gif SourceConnection Gets or sets a String containing the name of the SMO connection manager for the source/destination database.
ms215206.pubproperty(en-US,SQL.90).gif StoredProceduresList Gets or sets a StringCollection containing a comma-delimited list of stored procedure names.
ms215206.pubproperty(en-US,SQL.90).gif SuspendRequired Gets or sets a Boolean indicating whether the task should suspend when it encounters a breakpoint. This value is set by the run-time engine for the task or container when a breakpoint is encountered.
ms215206.pubproperty(en-US,SQL.90).gif TransferAllStoredProcedures A Boolean indicating whether all stored procedures in the master database of the source SQL Server are transferred, or only the specified stored procedures.
ms215206.pubproperty(en-US,SQL.90).gif Version  Returns the version of the task. This property is read-only. (inherited from Task)
ms215206.pubproperty(en-US,SQL.90).gif WaitForMe  Returns a Boolean that indicates whether the parent container should wait for completion of this task. This property is read-only. (inherited from Task)

Top

Public Methods

(see also Protected Methods )

  Name Description
ms215206.pubmethod(en-US,SQL.90).gif AcceptBreakpointManager Passes a BreakpointManager to a task. This method is called by the runtime and is not used in code.
ms215206.pubmethod(en-US,SQL.90).gif CanUpdate  (inherited from Task )
ms215206.pubmethod(en-US,SQL.90).gif Equals  Overloaded. (inherited from DtsObject )
ms215206.pubmethod(en-US,SQL.90).gif Execute Overridden. Runs the task.
ms215206.pubmethod(en-US,SQL.90).gif GetConnectionID  (inherited from Task )
ms215206.pubmethod(en-US,SQL.90).gif GetConnectionName  (inherited from Task )
ms215206.pubmethod(en-US,SQL.90).gif GetHashCode  Returns the hash code for this instance. (inherited from DtsObject)
ms215206.pubmethod(en-US,SQL.90).gif GetType  (inherited from Object )
ms215206.pubmethod(en-US,SQL.90).gif InitializeTask Overridden. Initializes the properties associated with the task. This method is called by the runtime and is not used in code.
ms215206.pubmethod(en-US,SQL.90).gif LoadFromXML This method is not callable by your application code. To load a package saved as .xml, use the Application.LoadPackage method.
ms215206.pubmethod(en-US,SQL.90).gifms215206.static(en-US,SQL.90).gif op_Equality  (inherited from DtsObject )
ms215206.pubmethod(en-US,SQL.90).gifms215206.static(en-US,SQL.90).gif op_Inequality  (inherited from DtsObject )
ms215206.pubmethod(en-US,SQL.90).gifms215206.static(en-US,SQL.90).gif ReferenceEquals  (inherited from Object )
ms215206.pubmethod(en-US,SQL.90).gif ResumeExecution Resumes execution of the task after pausing. The task or container is resumed by the run-time engine.
ms215206.pubmethod(en-US,SQL.90).gif SaveToXML This method is not callable by your application code. To save a package as .xml, use the Application.SaveToXml method.
ms215206.pubmethod(en-US,SQL.90).gif SuspendExecution Indicates that the executable needs to suspend. This method is called by the run-time engine.
ms215206.pubmethod(en-US,SQL.90).gif ToString  (inherited from Object )
ms215206.pubmethod(en-US,SQL.90).gif Update  (inherited from Task )
ms215206.pubmethod(en-US,SQL.90).gif Validate Overridden. Verifies that the component is properly configured.

Top

Protected Methods

  Name Description
ms215206.protmethod(en-US,SQL.90).gif Finalize  (inherited from Object )
ms215206.protmethod(en-US,SQL.90).gif MemberwiseClone  (inherited from Object )

Top

See Also

Reference

TransferStoredProceduresTask Class
Microsoft.SqlServer.Dts.Tasks.TransferStoredProceduresTask Namespace