TransferStoredProceduresTask Members

Articolo
12/15/2008

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

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

Torna all'inizio

Public Properties

	Nome	Description
	DebugMode	Gets or sets a Boolean indicating whether a task should determine whether breakpoints are enabled.
	DestinationConnection	Gets or sets a String containing the name of the SMO connection manager for the source/destination database.
	ExecutionValue	Overridden. Returns an object containing a count of the number of stored procedures that were transferred.
	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.
	SourceConnection	Gets or sets a String containing the name of the SMO connection manager for the source/destination database.
	StoredProceduresList	Gets or sets a StringCollection containing a comma-delimited list of stored procedure names.
	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.
	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.
	Version	Returns the version of the task. This property is read-only. (inherited from Task)
	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)

Torna all'inizio

Public Methods

(see also Protected Methods )

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