Package: SqlTraceUpload

CollapseAll image

Collapse image Properties


 Name   Value 
CertificateContext 0
CertificateObject  
CheckpointFileName  
CheckpointUsage Never
CheckSignatureOnLoad True
CreationDate 3/6/2007 4:18:14 PM
CreationName Microsoft.Package
CreatorComputerName  
CreatorName  
DebugMode False
DelayValidation False
Description  
DesignEvents  
DesignTimeProperties  
Disable False
DisableEventHandlers False
DumpDescriptor  
DumpOnAnyError False
EnableConfigurations True
EnableDump True
EncryptCheckpoints False
ExecutionDuration 0
ExecutionResult Success
ExecutionStatus None
FailPackageOnFailure False
FailParentOnFailure False
ForcedExecutionValue 0
ForceExecutionResult None
ForceExecutionValue False
HasExpressions False
ID {F389A8E6-5A17-4056-ABFD-C8B823F2092E}
IgnoreConfigurationsOnLoad False
InteractiveMode False
IsDefaultLocaleID False
IsolationLevel Serializable
LastModifiedProductVersion 13.0.1.23
LocaleID English (United States)
LoggingMode Enabled
MaxConcurrentExecutables -1
MaximumErrorCount 0
Name SqlTraceUpload
OfflineMode False
PackageFormatVersion 8
PackageLocation sql:Data Collector\SqlTraceUpload
PackagePath Data Collector\SqlTraceUpload
PackagePriorityClass Default
PackageServerName ALEN-PC\SQLSERVER2016
PackageStorageType MsSql
PackageType DTSDesigner100
ProtectionLevel DontSaveSensitive
SafeRecursiveProjectPackageExecution False
SaveCheckpoints False
SQLFolder Data Collector
SuppressConfigurationWarnings False
SuspendRequired False
TransactionOption Supported
UpdateObjects False
UpdatePackage True
VersionBuild 219
VersionComments  
VersionGUID {2B249201-CD59-40B8-97CA-C7FD482FE09C}
VersionMajor 10
VersionMinor 0

Collapse image Configuration settings


 Name   Description 
CacheDirectory  
CacheWindow  
CollectionSetUID  
CollectorTypeUID  
ConfigConnectionString  
DaysUntilExpiration  
ExitEventName  
InputParameters  
InstanceID  
InstanceName  
ItemID  
LoggingLevel  
LogID  
LoopEventName  
MDWConnectionString  
ParentLogID  
TargetConnectionString  

Collapse image Connection managers


 Name   Description 
ConfigConnection Connection used to get information about collection configuration and for logging purposes.
MdwConnection Connection used to upload collected data to a warehouse.
TargetConnection Connection used to get information from the monitored (target) instance.

Collapse image Executables


 Name   Description 
For Loop Container For Loop Container
SEQ - Default trace upload Sequence Container
SQL - Close trace Execute SQL Task
SQL - Get last upload time Execute SQL Task
SQL - Get snapshot id Execute SQL Task
SQL - Get trace info Execute SQL Task
SQL - Update data source Execute SQL Task
XML - Check use_default attribute XML Task

Collapse image Log entry information


 Name   Description 
Diagnostic Logs package diagnostics information, e.g. maximum concurrent executables
DiagnosticEx Logs more information on package execution with XML format

Collapse image Precedence constraints


 Name   Description 
Constraint  
Constraint 1  
Constraint 2  
Constraint 3  
Constraint 5  
Constraint 6  
Constraint 8  

Collapse image User defined variables


 Name   Description 
CacheDirectory  
CacheWindow  
CollectionSetUID  
CollectorTypeUID  
ConfigConnectionString  
Counter  
DaysUntilExpiration  
ExitEventName  
InputParameters  
InstanceID  
InstanceName  
ItemID  
LoggingLevel  
LogID  
LoopEventName  
MDWConnectionString  
ParentLogID  
RowCountIn  
SnapshotID  
SourceID  
TargetConnectionString  
TraceCurrentEventTime  
TraceCurrentFile  
TraceDroppedEventCount  
TraceID  
TraceInfoID  
TraceIsRunning  
TraceLastEventSequence  
TraceLocation  
TraceStartTime  
TraceUseDefault  

Collapse image See also


Package index