Package element: SQL - Get Last_Event_Sequence
Name | Value |
ApartmentThreaded | True |
BypassPrepare | True |
CodePage | 1252 |
Connection | MdwConnection |
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 | True |
ForcedExecutionValue | 0 |
ForceExecutionResult | None |
ForceExecutionValue | False |
HasExpressions | False |
HostType | Task |
ID | {1fe772eb-42ae-4641-af91-138c98b8fcba} |
IsDefaultLocaleID | True |
IsolationLevel | Serializable |
IsStoredProcedure | False |
LocaleID | English (United States) |
LoggingMode | Disabled |
MaximumErrorCount | 0 |
Name | SQL - Get Last_Event_Sequence |
ResultSetType | 2 |
SqlStatementSource | DECLARE @lastEventSequence BIGINT SET @lastEventSequence = -1 SELECT @lastEventSequence = [last_event_sequence] FROM [snapshots].[trace_info] WHERE [trace_info_id] = ? SELECT @lastEventSequence |
SqlStatementSourceType | Direct Input |
SuspendRequired | False |
TargetServerVersion | 130 |
TimeOut | 0 |
TransactionOption | Supported |
TypeConversionMode | 2 |
Version | 0 |
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 |