Jaa


ScriptObjectModel.TaskResult Property

Returns the DTSExecResult of the Script task, mapped to the corresponding member of the ScriptObjectModel.Results enumeration.

Namespace: Microsoft.SqlServer.Dts.Tasks.ScriptTask
Assembly: Microsoft.SqlServer.ScriptTask (in microsoft.sqlserver.scripttask.dll)

Syntax

'Declaration
Public Property TaskResult As Integer
public int TaskResult { get; set; }
public:
property int TaskResult {
    int get ();
    void set (int value);
}
/** @property */
public int get_TaskResult ()

/** @property */
public void set_TaskResult (int value)
public function get TaskResult () : int

public function set TaskResult (value : int)

Property Value

The DTSExecResult of the Script task, mapped to the corresponding member of the ScriptObjectModel.Results enumeration.

Remarks

Use the TaskResult property of the Dts object in Script task code to notify the package of the success or failure of the Script task.

The Script task can also return additional user-defined information about the results of its execution through the ExecutionValue property.

Example

The following sample of code for use inside a Script task demonstrates the use of the TaskResult property.

Dts.TaskResult = Dts.Results.Success

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 2005.

Target Platforms

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

See Also

Reference

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