Package element: DFT - Upload trace file
Name | Value |
[DRV - Add columns].[Derived Column Output].[dropped_event_count].[FriendlyExpression] | @[User::TraceDroppedEventCount] |
[DRV - Add columns].[Derived Column Output].[is_running].[FriendlyExpression] | @[User::TraceIsRunning] |
[DRV - Add columns].[Derived Column Output].[last_event_sequence].[FriendlyExpression] | ISNULL(EventSequence_Max) ? 0 : EventSequence_Max |
[DRV - Add columns].[Derived Column Output].[snapshot_id].[FriendlyExpression] | @[User::SnapshotID] |
[DRV - Add columns].[Derived Column Output].[trace_info_id].[FriendlyExpression] | @[User::TraceInfoID] |
[DRV - Add snapshot_id and trace_info_id].[Derived Column Output].[snapshot_id].[FriendlyExpression] | @SnapshotID |
[DRV - Add snapshot_id and trace_info_id].[Derived Column Output].[trace_info_id].[FriendlyExpression] | @[User::TraceInfoID] |
[ODB - Update trace_info].[SqlCommand] | {call snapshots.sp_trace_update_info(?, ?, ?, ?, ?, ?)} |
ApartmentThreaded | False |
AutoAdjustBufferSize | False |
AutoGenerateIDForNewObjects | True |
BLOBTempStoragePath | |
BufferTempStoragePath | |
CreationName | SSIS.Pipeline.5 |
DebugMode | False |
DefaultBufferMaxRows | 10000 |
DefaultBufferSize | 10485760 |
DelayValidation | True |
Description | Data Flow Task |
Disable | False |
DisableEventHandlers | False |
EnableCacheUpdate | True |
EnableDisconnectedColumns | False |
EngineThreads | 10 |
ExecutionDuration | 0 |
ExecutionResult | Success |
ExecutionStatus | None |
FailPackageOnFailure | False |
FailParentOnFailure | True |
ForcedExecutionValue | 0 |
ForceExecutionResult | None |
ForceExecutionValue | False |
HasExpressions | False |
HostType | Task |
ID | {96A9329D-379F-466F-970B-4A97A3FCF7A1} |
IsDefaultLocaleID | True |
IsolationLevel | Serializable |
IsSavingXml | False |
LocaleID | English (United States) |
LoggingMode | Disabled |
MaximumErrorCount | 0 |
Name | DFT - Upload trace file |
RunInOptimizedMode | True |
SuspendRequired | False |
TransactionOption | Supported |
Name | Description | Type |
AGG - Get max value of EventSequence | Aggregates and groups values in a dataset. | ComponentMetaDataCollection |
CNT - Error row count source | Counts the rows in a dataset. | ComponentMetaDataCollection |
CNT - Input row count | Counts the rows in a dataset. | ComponentMetaDataCollection |
CNT - Output row count | Counts the rows in a dataset. | ComponentMetaDataCollection |
Data Conversion | Data Conversion | ComponentMetaDataCollection |
DRV - Add columns | Updates column values using expressions | ComponentMetaDataCollection |
DRV - Add snapshot_id and trace_info_id | Updates column values using expressions | ComponentMetaDataCollection |
MLT - Split two ways | Creates copies of a dataset. | ComponentMetaDataCollection |
ODB - Read trace | OLE DB Source | ComponentMetaDataCollection |
ODB - Update trace_info | Executes an SQL command for each row in a dataset. | ComponentMetaDataCollection |
ODB - Write to output table | OLE DB Destination | ComponentMetaDataCollection |
BufferSizeTuning | The Data Flow changed the size of a buffer away from the default values. The event text includes the sizes and the reasons. | LogEntryInfos |
PipelineBufferLeak | After execution, some buffers were left outstanding. Some transform is hanging onto buffer references and if it freed them we would use a lot less memory. The logged text includes information about the transform that owned the buffer, and the ID of the buffer. | LogEntryInfos |
PipelineComponentTime | Information about each phase of validation and execution for each data flow component. The processing time of each phase is specified. | LogEntryInfos |
PipelineExecutionPlan | The execution plan of the data flow. | LogEntryInfos |
PipelineExecutionTrees | The input the scheduler had when forming the execution plan. | LogEntryInfos |
PipelineInitialization | Various information from Data Flow initialization. | LogEntryInfos |
Aggregate Output 1 | PathCollection | |
Data Conversion Output | PathCollection | |
Derived Column Output | PathCollection | |
Derived Column Output | PathCollection | |
Multicast Output 1 | PathCollection | |
Multicast Output 2 | PathCollection | |
OLE DB Source Error Output | PathCollection | |
OLE DB Source Output | PathCollection | |
Row Count Output 1 | PathCollection | |
Row Count Output 1 | PathCollection | |
TraceLoadScript | Variables | |
RowCountError | Variables | |
RowCountIn | Variables | |
RowCountOut | Variables | |
CacheDirectory | Variables | |
CacheWindow | Variables | |
CollectionSetUID | Variables | |
CollectorTypeUID | Variables | |
ConfigConnectionString | Variables | |
Counter | Variables | |
DaysUntilExpiration | Variables | |
ExitEventName | Variables | |
InputParameters | Variables | |
InstanceID | Variables | |
InstanceName | Variables | |
ItemID | Variables | |
LoggingLevel | Variables | |
LogID | Variables | |
LoopEventName | Variables | |
MDWConnectionString | Variables | |
ParentLogID | Variables | |
RowCountIn | Variables | |
SnapshotID | Variables | |
SourceID | Variables | |
TargetConnectionString | Variables | |
TraceCurrentEventTime | Variables | |
TraceCurrentFile | Variables | |
TraceDroppedEventCount | Variables | |
TraceID | Variables | |
TraceInfoID | Variables | |
TraceIsRunning | Variables | |
TraceLastEventSequence | Variables | |
TraceLocation | Variables | |
TraceStartTime | Variables | |
TraceUseDefault | Variables |