Package element: DFT - Upload trace file

CollapseAll image

Collapse image 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

Collapse image 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
SSIS diagram is missing

Collapse image See also


Package index