TaskHost.ExecValueVariable Property
Gets or sets the custom Variable that contains the execution results of the task.
Namespace: Microsoft.SqlServer.Dts.Runtime
Assembly: Microsoft.SqlServer.ManagedDTS (in microsoft.sqlserver.manageddts.dll)
Syntax
'Deklaracja
Public Property ExecValueVariable As Variable
public Variable ExecValueVariable { get; set; }
public:
property Variable^ ExecValueVariable {
Variable^ get ();
void set (Variable^ value);
}
/** @property */
public Variable get_ExecValueVariable ()
/** @property */
public void set_ExecValueVariable (Variable value)
public function get ExecValueVariable () : Variable
public function set ExecValueVariable (value : Variable)
Property Value
A custom Variable that contains the execution results.
Remarks
The name of the custom variable that contains the execution result for the task. The default value of this property is none, which indicates that the result is not set to a variable in the package.
The TaskHost exposes the ExecutionValue property through the ExecValueVariable property. The task uses the ExecutionValue property to provide optional, supplemental information about the results of execution. The ExecValueVariable property allows the user to map the ExecutionValue that the task returns to any variable that is visible to the task. The package could then use the value that is returned as one of the criteria for determining the next task to run in the control flow. For example, if a task deletes rows from a table as part of its Execute method, the task might return the number of rows deleted as the ExecutionValue. Clients of the task could then use this value to define expressions in precedence constraints between tasks.
Thread Safety
Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.
Platforms
Development Platforms
For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server.
Target Platforms
For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server.