Common SSIS package-common attributes

Let's talk about the common attributes of the SSIS package today. This part is not practical, but it is just a few simple introductions.Regardless of the type in the packageTask, All have some common attributes, which are listed here:

• Disable: set this attribute to true so that the task cannot be executed.
• Delayvalidation: if it is set to true, the attribute in the task is verified only when it is run. It is useful to enter an external parameter value for the task in non-connection status but not during deployment. Its default value is false.
• Description: This attribute describes the situation of a task. The default value is <Task Name>. If multiple task types are the same, you can set it to <Task Name 1> (Number 1 increments ). This attribute is not unique. You only need to accurately describe the task so that others in the project can understand it.
• Execvaluevariable: stores the user variables output by the task. The default value is <none>, not output.
• Failpackageonfailure: set this attribute to true. When a task in the package fails, the entire package fails to be executed. The default attribute is false.
• Failparentonfailure: set this attribute to true. If this task fails, its upper-layer tasks will also fail. Its upper-layer task may be a package or iner.
• ID: the unique ID automatically generated for each task, is a string in the guid format, for example, {BK4FH3I-RDN3-I8RF-KU3F-JF83AFJRLS}
• Isolationlevel: if the transaction mode is set, you can set the transaction isolation level. There are several isolation levels of transactions: Read committed readcommitted, read not committed readcommitted, repeatableread, serializable, unspecified, and snapshot. The default attribute is serialized. These options are based on SQL Server transactions.
• Loggingmode: Set the log record mode of the task. Optional values: Set useparentsetting with the parent task, enabled, and disabled. The default value is set by the parent task, which indicates that the task uses the logging mode of the Upper-layer task.
• Name: This attribute is associated with tasks. The default value is <Task Name>. If there are multiple tasks of the same type, you can set <task name1> (Number 1 auto-increment ). As an SSIS designer, you should modify this attribute frequently to make it more readable, but it must be unique in this package.
• Transactionoption: sets the transaction attribute of a task. The value can be notsupported, which is not supported. The supported value is required. The default settings are supported so that transactions can be used in tasks.

EachTaskThere is a corresponding editing page to present its expression, you can modify it dynamically.