Package element: TRC - Generate Trace Start Script

CollapseAll image

Collapse image Properties


 Name   Value 
ApartmentThreaded False
CreationName DTS.TraceStartScriptTask.4
DebugMode False
DelayValidation True
Description Trace Start Script
Destination TraceScript
Disable False
DisableEventHandlers False
ExecutionDuration 0
ExecutionResult Success
ExecutionStatus None
FailPackageOnFailure False
FailParentOnFailure True
ForcedExecutionValue 0
ForceExecutionResult None
ForceExecutionValue False
HasExpressions True
HostType Task
ID {A1508E93-DDD6-4E3D-BE78-46B59503E7AF}
InputParameters <?xml version="1.0" encoding="utf-8"?><ns:SqlTraceCollector xmlns:ns="DataCollectorType" normalize_sql="0" normalize_plans="0" normalize_procedures="0" normalize_connections="0" normalize_default="1"><Events><EventType id ="6" name="Performance"><Event id="58" name="Auto Stats" /><Event id="165" name="Performance statistics" /><Event id="146" name="Showplan XML Statistics Profile" /></EventType><EventType id="13" name="TSQL"><Event id="12" name="SQL:BatchCompleted" columnslist="1, 3, 9, 10, 13, 16, 17, 18" /><Event id="13" name="SQL:BatchStarting" /><Event id="41" name="SQL:StmtCompleted" /><Event id="166" name="SQL:StmtRecompile" /></EventType><EventType id="20" name="CLR"><Event id="196" name="Assembly Load" /></EventType><EventType id="1" name="Cursors"><Event id="53" name="CursorOpen" /><Event id="75" name="CursorRecompile" /><Event id="76" name="CursorImplicitConversion" /><Event id="78" name="CursorClose" /></EventType></Events><Filters><Filter columnid="13" columnname="Duration" logical_operator="AND" comparison_operator="GE" value="1000L"/><Filter columnid="10" columnname="ApplicationName" logical_operator="AND" comparison_operator="LIKE" value="Data Collector"/><Filter columnid="10" columnname="ApplicationName" logical_operator="AND" comparison_operator="EQ" value="NULL"/><Filter columnid="18" columnname="CPU" logical_operator="AND" comparison_operator="EQ" value="20"/><Filter columnid="14" columnname="StartTime" logical_operator="AND" comparison_operator="GT" value="2007-02-09 13:40:00"/></Filters></ns:SqlTraceCollector>
IsDefaultLocaleID True
IsolationLevel Serializable
LocaleID English (United States)
LoggingMode Disabled
MaxFileSize 10
MaximumErrorCount 0
MaxNumberOfFiles 10
Name TRC - Generate Trace Start Script
SuspendRequired False
TraceFileLocation C:\Users\macies\AppData\Local\Temp\ecodedc\DC_Trace_ALEN-PC.MSSQL.1.f37780d4-fea7-4271-90b2-fa553ad4ca91.0
TransactionOption NotSupported

Collapse image Elements


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

Collapse image See also


Package index