Package element: FEF - For each collected cache file try upload
Name | Value |
CreationName | STOCK:FOREACHLOOP |
DebugMode | False |
DelayValidation | False |
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 | {91A4B7F7-385C-47C2-AA89-08B832F71599} |
IsDefaultLocaleID | True |
IsolationLevel | Serializable |
LocaleID | English (United States) |
LoggingMode | Disabled |
MaximumErrorCount | 0 |
Name | FEF - For each collected cache file try upload |
SuspendRequired | False |
TransactionOption | Supported |
Name | Description | Type |
DFT - Upload collection snapshot | Data Flow Task | Executables |
FST - Delete uploaded cache file | File System Task | Executables |
SQL - Log Package Iteration | Execute SQL Task | Executables |
SQL - Log Package Stats | Execute SQL Task | Executables |
{BB52AFAE-60A1-42A7-9C13-52B21293D219} | ForEachEnumerator | |
Constraint | PrecedenceConstraints | |
Constraint 1 | PrecedenceConstraints | |
Constraint 2 | PrecedenceConstraints | |
CurrentCollectionCacheFileName | Variables | |
RowCount | Variables | |
CacheDirectory | Variables | |
CacheWindow | Variables | |
CollectionCacheFileName | Stores snapshots of dm_exec_requests | Variables |
CollectionCacheFileNameOutput | Stores snpashots of dm_exec_requests. This variable is used as temporary cached file name during the upload. | Variables |
CollectionCacheFilePrefixPattern | Prefix for files related to dm_exec_requets collection | Variables |
CollectionSetUID | Variables | |
CollectorTypeUID | Variables | |
ConfigConnectionString | Variables | |
DaysUntilExpiration | Variables | |
ExitEventName | Variables | |
InputParameters | Variables | |
InstanceID | Variables | |
InstanceName | Variables | |
InterestingQueries_HighCpuUsage | Variables | |
InterestingQueries_HighIoCount | Variables | |
InterestingQueries_HighMemoryUsage | Variables | |
InterestingQueries_HighTransactionCount | Variables | |
InterestingQueries_LargeResultset | Variables | |
InterestingQueries_LongRunningRequest | Variables | |
InterestingQueries_LongWaitingRequest | Variables | |
InterestingQueriesCount | Variables | |
InterestingQueriesLastSnapshotFileName | Stores the most recent copy of snapshot of dm_exec_query_stats saved from the previous execution of this package. | Variables |
InterestingQueriesLastSnapshotFileNameOutput | Stores temporary copy of the most recent snapshot of dm_exec_query_stats | Variables |
InterestingQueriesSnapshotFileNamePrefixPattern | Prefix for files related to dm_exec_query_stats collection. | Variables |
ItemID | Variables | |
LoggingLevel | Variables | |
LogID | Variables | |
LoopDuration | Variables | |
LoopEventName | Variables | |
MDWConnectionString | Variables | |
ParentLogID | Variables | |
SnapshotId | Variables | |
SnapshotQueryStatsQuery | Variables | |
SourceId | Variables | |
TargetConnectionString | Variables | |
TopThreshold | Variables |