Package element: SQL - Check trace info
Properties
| Name | Value |
| ApartmentThreaded | True |
| BypassPrepare | True |
| CodePage | 1252 |
| Connection | ConfigConnection |
| CreationName | Microsoft.SqlServer.Dts.Tasks.ExecuteSQLTask.ExecuteSQLTask, Microsoft.SqlServer.SQLTask, Version=13.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91 |
| DebugMode | False |
| DelayValidation | False |
| Description | Execute SQL Task |
| Disable | False |
| DisableEventHandlers | False |
| ExecutionDuration | 0 |
| ExecutionResult | Success |
| ExecutionStatus | None |
| FailPackageOnFailure | False |
| FailParentOnFailure | False |
| ForcedExecutionValue | 0 |
| ForceExecutionResult | None |
| ForceExecutionValue | False |
| HasExpressions | False |
| HostType | Task |
| ID | {782c9195-15b2-4260-bff9-6d85b486e50f} |
| IsDefaultLocaleID | True |
| IsolationLevel | Serializable |
| IsStoredProcedure | False |
| LocaleID | English (United States) |
| LoggingMode | Disabled |
| MaximumErrorCount | 0 |
| Name | SQL - Check trace info |
| ResultSetType | 2 |
| SqlStatementSource | DECLARE @status INT SET @status = 2 SELECT @status = CASE t.status WHEN 1 THEN 1 ELSE 0 END FROM sys.traces t WHERE t.path LIKE (? + N'%.trc') SELECT @status |
| SqlStatementSourceType | Direct Input |
| SuspendRequired | False |
| TargetServerVersion | 130 |
| TimeOut | 0 |
| TransactionOption | Supported |
| TypeConversionMode | 2 |
| Version | 0 |
Elements
| Name | Description | Type |
| ExecuteSQLExecutingQuery | Provides information about executing an SQL query. | LogEntryInfos |
| CacheDirectory | Variables | |
| CacheWindow | Variables | |
| CollectionSetUID | Variables | |
| CollectorTypeUID | Variables | |
| ConfigConnectionString | Variables | |
| Counter | Variables | |
| DaysUntilExpiration | Variables | |
| ExitEventName | Variables | |
| InputParameters | Variables | |
| InstanceID | Variables | |
| InstanceName | Variables | |
| ItemID | Variables | |
| LoggingLevel | Variables | |
| LogID | Variables | |
| LoopEventName | Variables | |
| MDWConnectionString | Variables | |
| ParentLogID | Variables | |
| RowCountIn | Variables | |
| SnapshotID | Variables | |
| SourceID | Variables | |
| TargetConnectionString | Variables | |
| TraceCurrentEventTime | Variables | |
| TraceCurrentFile | Variables | |
| TraceDroppedEventCount | Variables | |
| TraceID | Variables | |
| TraceInfoID | Variables | |
| TraceIsRunning | Variables | |
| TraceLastEventSequence | Variables | |
| TraceLocation | Variables | |
| TraceStartTime | Variables | |
| TraceUseDefault | Variables |
See also