ScriptObjectModel.ExecutionValue Property

Gets or sets a user-defined object that provides additional information about the results of task execution.

命名空间: Microsoft.SqlServer.Dts.Tasks.ScriptTask
程序集: Microsoft.SqlServer.ScriptTask (in microsoft.sqlserver.scripttask.dll)

语法

声明
Public Property ExecutionValue As Object

public Object ExecutionValue { get; set; }

public:
property Object^ ExecutionValue {
    Object^ get ();
    void set (Object^ value);
}

/** @property */
public Object get_ExecutionValue ()

/** @property */
public void set_ExecutionValue (Object value)

public function get ExecutionValue () : Object

public function set ExecutionValue (value : Object)

属性值

A user-defined object that provides additional information about the results of task execution.

备注

Use the ExecutionValue property of the Dts object in Script task code to return additional user-defined information about the results of task execution.This property gives the developer a way to exchange data with the package in addition to events and the separate DTSExecResult value. For example, if a Script task deletes rows from a table, it might return the number of rows deleted as the ExecutionValue. Subsequent tasks could then use this value to make decisions for additional processing.

The Script task returns its separate DTSExecResult through the TaskResult property as a value from the corresponding member of the ScriptObjectModel.Results enumeration.

示例

The following sample of code for use inside a Script task demonstrates how the ExecutionValue can also be used to determine the path of the workflow.

Dim rowsAffected as Integer
...
rowsAffected = 1000
Dts.ExecutionValue = rowsAffected

线程安全

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.

平台

开发平台

有关支持的平台列表，请参阅安装 SQL Server 2005 的硬件和软件要求。

目标平台

有关支持的平台列表，请参阅安装 SQL Server 2005 的硬件和软件要求。

请参阅

参考

ScriptObjectModel Class
ScriptObjectModel Members
Microsoft.SqlServer.Dts.Tasks.ScriptTask Namespace