Package: SqlTraceCollect

CollapseAll image

Collapse image Properties


 Name   Value 
CertificateContext 0
CertificateObject  
CheckpointFileName  
CheckpointUsage Never
CheckSignatureOnLoad True
CreationDate 2/14/2007 3:06:05 PM
CreationName Microsoft.Package
CreatorComputerName MACIES4
CreatorName REDMOND\macies
DebugMode False
DelayValidation True
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 True
ForcedExecutionValue 0
ForceExecutionResult None
ForceExecutionValue False
HasExpressions False
ID {0E149FC9-1046-4DE6-98BF-4B22ED6F6C42}
IgnoreConfigurationsOnLoad False
InteractiveMode False
IsDefaultLocaleID False
IsolationLevel Serializable
LastModifiedProductVersion 13.0.1.23
LocaleID English (United States)
LoggingMode Enabled
MaxConcurrentExecutables -1
MaximumErrorCount 0
Name SqlTraceCollect
OfflineMode False
PackageFormatVersion 8
PackageLocation sql:Data Collector\SqlTraceCollect
PackagePath Data Collector\SqlTraceCollect
PackagePriorityClass Default
PackageServerName ALEN-PC\SQLSERVER2016
PackageStorageType MsSql
PackageType DTSDesigner100
ProtectionLevel EncryptSensitiveWithUserKey
SafeRecursiveProjectPackageExecution False
SaveCheckpoints False
SQLFolder Data Collector
SuppressConfigurationWarnings True
SuspendRequired False
TransactionOption Supported
UpdateObjects False
UpdatePackage True
VersionBuild 87
VersionComments  
VersionGUID {149519E7-B008-4BE2-9408-766D8CC64951}
VersionMajor 1
VersionMinor 0

Collapse image Configuration settings


 Name   Description 
CacheDirectory  
CacheWindow  
CollectionSetUID  
CollectorTypeUID  
ConfigConnectionString  
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 
Foreach Loop - Monitor Trace Foreach Loop Container
SQL - Close trace if running Execute SQL Task
SQL - Execute Trace Start Script Execute SQL Task
SQL - Stop Trace Execute SQL Task
TRC - Generate Trace Start Script Trace Start Script

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 5  

Collapse image User defined variables


 Name   Description 
CacheDirectory  
CacheWindow  
CollectionSetUID  
CollectorTypeUID  
ConfigConnectionString  
ExitEventName  
InputParameters  
InstanceID  
InstanceName  
ItemID  
LoggingLevel  
LogID  
LoopDuration  
LoopEventName  
MDWConnectionString  
ParentLogID  
TargetConnectionString  
TraceErrorCode  
TraceID  
TraceLocation  
TraceScript  

Collapse image See also


Package index