DTS Programming

Step Object

The Step object controls the flow and execution of tasks within the Data Transformation Services (DTS) package. Each step is associated with a single task, although association with no task is possible. Step execution sequence is determined by the precedence constraints. A step cannot start execution until all its precedence constraints are satisfied.

Collections
PrecedenceConstraints Collection Properties Collection

Properties
ActiveXScript Property FunctionName Property
AddGlobalVariables Property IsPackageDSORowset Property
CloseConnection Property JoinTransactionIfPresent Property
CommitSuccess Property Name Property
Description Property Parent Property
DisableStep Property RelativePriority Property
ExecuteInMainThread Property RollbackFailure Property
ExecutionResult Property ScriptLanguage Property
ExecutionStatus Property StartTime Property
ExecutionTime Property TaskName Property
FinishTime Property  

Methods
Execute (Package) Method GetExecutionErrorInfo Method

Remarks

The Step object is compatible with Microsoft® SQL Server™ version 7.0. For more information about an extended version of this object, see Step2 Object.

See Also

Creating DTS Package Workflow and Tasks

Steps Collection