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