Package element: TRC - Generate Trace Start Script
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 |
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 |