ScriptObjectModel.TaskResult Property
Returns the DTSExecResult of the Script task.
Namespace: Microsoft.SqlServer.Dts.Tasks.ScriptTask
Assembly: Microsoft.SqlServer.ScriptTask (in Microsoft.SqlServer.ScriptTask.dll)
Syntax
'Declaration
Public Property TaskResult As Integer
Get
Set
'Usage
Dim instance As ScriptObjectModel
Dim value As Integer
value = instance.TaskResult
instance.TaskResult = value
public int TaskResult { get; set; }
public:
property int TaskResult {
int get ();
void set (int value);
}
member TaskResult : int with get, set
function get TaskResult () : int
function set TaskResult (value : int)
Property Value
Type: System.Int32
The DTSExecResult of the Script task.
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.
Examples
The following sample of code for use inside a Script task demonstrates the use of the TaskResult property.
Dts.TaskResult = ScriptResults.Success