Share via

TransferErrorMessagesTask Members

  • Article

Provides the ability to copy one or more SQL Server user-defined error messages to another instance of SQL Server. This class cannot be inherited.

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

Public Constructors

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

Top

Public Properties

  Name Description
ms215027.pubproperty(en-US,SQL.90).gif DebugMode Gets or sets a Boolean indicating whether a task should determine whether breakpoints are enabled.
ms215027.pubproperty(en-US,SQL.90).gif DestinationConnection Gets or sets a String containing the name of the SMO connection manager for the destination database.
ms215027.pubproperty(en-US,SQL.90).gif ErrorMessageLanguagesList Gets or sets a StringCollection containing the user-defined error messages to transfer.
ms215027.pubproperty(en-US,SQL.90).gif ErrorMessagesList Gets or sets a StringCollection containing the IDs of the languages to transfer.
ms215027.pubproperty(en-US,SQL.90).gif ExecutionValue Overridden. Returns an object containing the number of error messages that were transferred.
ms215027.pubproperty(en-US,SQL.90).gif IfObjectExists Gets or sets a value from the IfObjectExists enumeration indicating indicating if the task should fail, overwrite, or skip the transfer of the errror message if an error message with the same name exists at the destination.
ms215027.pubproperty(en-US,SQL.90).gif SourceConnection Gets or sets a String containing the name of the SMO connection manager for the source database.
ms215027.pubproperty(en-US,SQL.90).gif SuspendRequired Gets or sets a Boolean indicating whether a task should suspend if it encounters a breakpoint. This value is set by the run-time engine for the tasks and containers when a breakpoint is encountered.
ms215027.pubproperty(en-US,SQL.90).gif TransferAllErrorMessages Gets or sets a Boolean indicating whether all user-defined error messages at the source should be transferred, or only the specified error messages.
ms215027.pubproperty(en-US,SQL.90).gif Version  Returns the version of the task. This property is read-only. (inherited from Task)
ms215027.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
ms215027.pubmethod(en-US,SQL.90).gif AcceptBreakpointManager Allows the task to create, remove, and check the status of breakpoints. This method is called by the run-time engine when a task or container is created and is not used in code.
ms215027.pubmethod(en-US,SQL.90).gif CanUpdate  (inherited from Task )
ms215027.pubmethod(en-US,SQL.90).gif Equals  Overloaded. (inherited from DtsObject )
ms215027.pubmethod(en-US,SQL.90).gif Execute Overridden. Runs the task as part of a package workflow.
ms215027.pubmethod(en-US,SQL.90).gif GetConnectionID  (inherited from Task )
ms215027.pubmethod(en-US,SQL.90).gif GetConnectionName  (inherited from Task )
ms215027.pubmethod(en-US,SQL.90).gif GetHashCode  Returns the hash code for this instance. (inherited from DtsObject)
ms215027.pubmethod(en-US,SQL.90).gif GetType  (inherited from Object )
ms215027.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.
ms215027.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.
ms215027.pubmethod(en-US,SQL.90).gifms215027.static(en-US,SQL.90).gif op_Equality  (inherited from DtsObject )
ms215027.pubmethod(en-US,SQL.90).gifms215027.static(en-US,SQL.90).gif op_Inequality  (inherited from DtsObject )
ms215027.pubmethod(en-US,SQL.90).gifms215027.static(en-US,SQL.90).gif ReferenceEquals  (inherited from Object )
ms215027.pubmethod(en-US,SQL.90).gif ResumeExecution Resumes execution of the task after pausing. The task is resumed by the run-time engine.
ms215027.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.
ms215027.pubmethod(en-US,SQL.90).gif SuspendExecution Called by the run-time engine when the executable needs to suspend.
ms215027.pubmethod(en-US,SQL.90).gif ToString  (inherited from Object )
ms215027.pubmethod(en-US,SQL.90).gif Update  (inherited from Task )
ms215027.pubmethod(en-US,SQL.90).gif Validate Overridden. Allows the container to determine if it contains invalid settings that will prevent it from executing successfully.

Top

Protected Methods

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

Top

See Also

Reference

TransferErrorMessagesTask Class
Microsoft.SqlServer.Dts.Tasks.TransferErrorMessagesTask Namespace