Package element: Foreach Loop - Monitor Trace
Properties
| Name | Value |
| CreationName | STOCK:FOREACHLOOP |
| DebugMode | False |
| DelayValidation | True |
| Description | Foreach Loop Container |
| Disable | False |
| DisableEventHandlers | False |
| ExecutionDuration | 0 |
| ExecutionResult | Success |
| ExecutionStatus | None |
| FailPackageOnFailure | False |
| FailParentOnFailure | True |
| ForcedExecutionValue | 0 |
| ForceExecutionResult | None |
| ForceExecutionValue | False |
| HasExpressions | True |
| ID | {AC652D98-8CD6-4256-BEB0-7B937A9F6EFC} |
| IsDefaultLocaleID | True |
| IsolationLevel | Serializable |
| LocaleID | English (United States) |
| LoggingMode | Disabled |
| MaximumErrorCount | 0 |
| Name | Foreach Loop - Monitor Trace |
| SuspendRequired | False |
| TransactionOption | Supported |
Elements
| Name | Description | Type |
| SQL - Check if Trace is Running | Execute SQL Task | Executables |
| SQL - Log Package Iteration | Execute SQL Task | Executables |
| SQL - Log Package Stats | Execute SQL Task | Executables |
| SQL - Recreate Trace | Execute SQL Task | Executables |
| {710AEAF2-45BD-4AB2-9EAF-FB6268AD10A2} | ForEachEnumerator | |
| Constraint | PrecedenceConstraints | |
| Constraint 1 | PrecedenceConstraints | |
| Constraint 2 | PrecedenceConstraints | |
| Constraint 3 | PrecedenceConstraints | |
| CacheDirectory | Variables | |
| CacheWindow | Variables | |
| CollectionSetUID | Variables | |
| CollectorTypeUID | Variables | |
| ConfigConnectionString | Variables | |
| ExitEventName | Variables | |
| InputParameters | Variables | |
| InstanceID | Variables | |
| InstanceName | Variables | |
| ItemID | Variables | |
| LoggingLevel | Variables | |
| LogID | Variables | |
| LoopDuration | Variables | |
| LoopEventName | Variables | |
| MDWConnectionString | Variables | |
| ParentLogID | Variables | |
| TargetConnectionString | Variables | |
| TraceErrorCode | Variables | |
| TraceID | Variables | |
| TraceLocation | Variables | |
| TraceScript | Variables |
See also