Search notes:

Microsoft.SqlServer.Dts.Runtime.DTSExecResult (enum)

`Canceled`	3
`Completion`	2
`Failure`	1
`Success`	0

See also

The TaskResult property of Microsoft.SqlServer.Dts.Tasks.ScriptTask.ScriptObjectModel and the ExecutionResult property of Microsoft.SqlServer.Dts.Runtime.DtsContainer and the Execution() method of Microsoft.SqlServer.Dts.Runtime.Package.