DTS Programming
NestedExecutionLevel Property
The NestedExecutionLevel property specifies the number of times a Data Transformation Services (DTS) package that contains an Execute Package task recursively executes the same or another package that also contains an Execute package task.
Applies To
| Package2 Object |
Syntax
object.NestedExecutionLevel [= value]
| Part | Description |
|---|---|
| object | Expression that evaluates to a Package2 object |
| value | Nesting depth of Execute Package invocations |
Data Type
Long
Modifiable
Read-only
Prototype (C/C++)
HRESULT GetNestedExecutionLevel(long *pVal);
Remarks
The innermost package in the calling sequence will fail if the NestedExecutionLevel property reaches a preset value (32). This property can be used to detect excessive recursive calls by Execute Package tasks before this limit is reached.