Export (0) Print
Expand All

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)

'Declaration
Public Property TaskResult As Integer 
	Get 
	Set
'Usage
Dim instance As ScriptObjectModel 
Dim value As Integer 

value = instance.TaskResult

instance.TaskResult = value

Property Value

Type: Int32
The DTSExecResult of the Script task.

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.

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

Dts.TaskResult = ScriptResults.Success

Community Additions

ADD
Show:
© 2014 Microsoft