TaskHost.ExecutionValue Property

Returns the result of the task execution. This property is read-only.

Namespace: Microsoft.SqlServer.Dts.Runtime
Assembly: Microsoft.SqlServer.ManagedDTS (in microsoft.sqlserver.manageddts.dll)

public Object ExecutionValue { get; }
/** @property */
public Object get_ExecutionValue ()

public function get ExecutionValue () : Object

Property Value

A user-defined object.

A task can use the ExecutionValue property to provide information about the results of the Execute method. This optional information supplements the Success or Failure status returned by the ExecutionResult property. For example, if a task deletes rows from a table, the task might return the number of rows deleted as the ExecutionValue.

However, to use the ExecutionValue later in the workflow of the package, for example, in a precedence constraint, you must save its value in an existing package variable. You use the ExecValueVariable property to specify the variable that will hold the ExecutionValue.

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.

Development Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

Target Platforms

Community Additions