Varigence, Inc.

This value specifies the mode that should be used to execute the children of the container or package. Parallel directly matches the SSIS behavior and will require that precedence constraints are created manually for all task connections. Linear will automatically create precedence constraints so that tasks will run one after the other in the order that they are specified in the Biml. Linear is primarily useful for scripting scenarios where creating precedence constraints would be tedious.

Specifies the name of the object. This name can be used to reference this object from anywhere else in the program.

This value specifies a direct reference to the table that will be used to store automatically created package configurations in the event that the AutoCreateConfigurationType property is set to Sql.

This value specifies whether or not package configurations will be automatically created and where they will be stored.

This value specifies the path to the file in which checkpoint information is saved. Checkpoint information can be used to restart a package if it fails.

This value specifies whether a package can be restarted and how the checkpoint file is used. The default value is Never, which means that the package cannot be restarted.

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.

This value specifies whether the package is disabled. The default value is False.

This value specifies whether the event handlers for this task, container, or package should be prevented from executing. The default value is False.

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.

This value determines whether the parent container will fail when a child container failes. The default value is False.

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.

This property specifies the data type of the value stored in the ForceExecutionValue property.

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.

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.

Allows the developer to specify a unique identifier (GUID) for the package. This can be used to retain a consistent ID between builds.

Sets the Isolation Level which controls how Transactions behave for this container.

This specifies the default language to be used by this task and its descendants.

This value specifies whether logging is enabled or disabled by the container or by the parent container. The default value is UseParentSetting.

This value specifies the maximum number of concurrently running threads a package is allowed to create.

This value specifies the maximum number of errors allowed to occur before a package is forced to stop running. The default value is 1.

This specifies a file path fragment to use for emitting output files for this package. It is most commonly employed to ensure that the output files for multiple packages will be placed into the same output directory. PackageSubpath will override the default package location behavior. Packages will no longer be emitted under OutputDirectory\Type\PackageName.dtsx but instead OutputDirectory\\PackageName.dtsx

This is a tag for the type or use of this package. It is used for documentation and to determine the folder into which to place generated output files.

This value specifies a thread processing priority level for the package.

This value specifies the level of data protection for the package.

This value specifies whether checkpoints are saved during package execution. The value must be set to True to enable a package to be restarted.

This value specifies whether warnings generated by configurations for this package are suppressed.

This value specifies the transaction context in which this task will execute.