Returning Results from the Script Task

APPLIES TO: yesSQL Server, including on Linux yesAzure SQL Database yesAzure SQL Data Warehouse noParallel Data Warehouse

The Script task uses the TaskResult and the optional ExecutionValue properties to return status information to the Integration Services runtime that can be used to determine the path of the workflow after the Script task has finished.


The TaskResult property reports whether the task succeeded or failed. For example:

Dts.TaskResult = ScriptResults.Success


The ExecutionValue property optionally returns a user-defined object that quantifies or provides more information about the success or failure of the Script task. For example, the FTP task uses the ExecutionValue property to return the number of files transferred. The Execute SQL task returns the number of rows affected by the task. The ExecutionValue can also be used to determine the path of the workflow. For example:

Dim rowsAffected as Integer


rowsAffected = 1000

Dts.ExecutionValue = rowsAffected