Package element: DFT - Upload trace file
Properties
| 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 |
Elements
| 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 |
See also