Update Statistics Task Element

API Type:
Varigence.Languages.Biml.Task.AstUpdateStatisticsTaskNode
X-Ref:

Attributes

AttributeAPI TypeDefaultDescription
ConnectionNameAstAdoNetConnectionNode 
This value specifies the ADO.NET connection to use for the task. This is a required reference to an existing definiton.
DatabaseSelectionModeMaintenancePlanDatabaseSelectionModeAll
This value specifies whether tables, views, or both can be selected for inclusion in the task. This is a required property
NameString 
Specifies the name of the object. This name can be used to reference this object from anywhere else in the program. This is a required property
ObjectSelectionModeMaintenancePlanObjectSelectionModeTables
This value specifies which tables or indexes to include in the task. This is a required property
DelayValidationBooleanfalse
This value specifies whether the validation of the Dataflow task in SSIS should be delayed until the package is executed. DelayValidation is most often used when the ETL process references tables and other server assets that were created in an earlier stage of the data processing run.
DisabledBooleanfalse
This value specifies whether the item is disabled. The default value is False.
DisableEventHandlersBooleanfalse
This value specifies whether the event handlers for this task, container, or package should be prevented from executing. The default value is False.
ExecutionValueVariableNameAstVariableBaseNode 
Specifies a variable to hold the execution results of this component. This references an existing definiton.
FailPackageOnFailureBooleanfalse
This value determines whether the container will fail when a container component fails. If this container corresponds to a package, then the only valid value is False.
FailParentOnFailureBooleanfalse
This value determines whether the parent container will fail when a child container failes. The default value is False.
ForcedExecutionValueString"0"
If the ForceExecutionValue property is set to True, then the container will return the value stored in this property as its execution value. Otherwise, this value will be ignored. The default value for ForecedExecutionValue is 0.
ForcedExecutionValueDataTypeTypeCodeInt32
This property specifies the data type of the value stored in the ForceExecutionValue property.
ForceExecutionResultForceExecutionResultNone
This value indicates whether a specified execution result value will result if the container runs. The default value is None, which means that the container does not force a specified outcome.
ForceExecutionValueBooleanfalse
Gets or sets a Boolean that indicates whether the execution value of the container should be forced to contain the value specified in the ForcedExecutionValue property.
IdGuid00000000-0000-0000-0000-000000000000
Allows the developer to specify a unique identifier (GUID) for the package. This can be used to retain a consistent ID between builds.
IgnoreDatabasesInNotOnlineStateBooleanFalse
This value specifies whether the task should skip databases that are offline.
IsolationLevelIsolationLevelSerializable
Sets the Isolation Level which controls how Transactions behave for this container.
LanguageLanguageInherited
This specifies the default language to be used by this task and its descendants.
LoggingModeLoggingModeInherit
This value specifies whether logging is enabled or disabled by the container or by the parent container. The default value is UseParentSetting.
MaxErrorCountInt321
This value specifies the maximum number of errors allowed to occur before a package is forced to stop running. The default value is 1.
ServerVersionInt329
This value specifies the server version to use for the task.
TransactionModeContainerTransactionModeJoin
This value specifies the transaction context in which this task will execute.
UpdateSampleValueInt3250
This value specifies the number of rows of the percentage of rows to sample (depending on the setting of the UpdateScanType property).
UpdateScanTypeUpdateStatisticsTaskScanTypeFullScan
This value specifies the type of scan to be used.
UpdateTypeUpdateStatisticsTaskUpdateTypeAllExistingStatistics
This value specifies the type of update to be performed.

Singleton Children

ChildAPI TypeDescription
<PrecedenceConstraints />AstTaskflowPrecedenceConstraintsNodeThe AstTaskflowPrecedenceConstraintsNode type corresponds directly to a precedence constraint in a SQL Server Integration Services task control flow.

Collection Children

ChildAPI TypeDescription
<Annotations>
    <Annotation />
</Annotations>		AstAnnotationNode
This is a collection of annotation items that can be used to specify documentation, tags, or other information. Annotations are particularly useful for storing information about nodes that can be used by BimlScript code.
<Databases>
    <Database />
</Databases>		String
This is a collection of the names of the databases to include in the task
<Events>
    <Event />
</Events>		AstTaskEventHandlerNode
This is a collection of event handlers that can respond to SQL Server Integration Services events that are raised on this task.
<Expressions>
    <Expression />
</Expressions>		AstPropertyExpressionNode
This is a collection of SSIS expression definitions for property value overrides that are specific to this task, container, or package.
<LogEvents>
    <LogEvent />
</LogEvents>		AstLogEventNode
This is a container for log event definitions that are specific to this task, container, or package.
<LogProviders>
    Multiple Choices...
</LogProviders>		AstLogProviderBaseNode
Defines the log providers to use for the SSIS task or container
This is a container for log provider definitions that are specific to this task, container, or package.
<Objects>
    <Object />
</Objects>		String
This is a collection of the names of the objects that should be included in the task.
<Variables>
    <Variable />
</Variables>		AstVariableNode
This is a container for variable definitions that are specific to this task, container, or package.