The Task Group component represents execution of one or more transformation tasks in the control flow.
Transformation tasks define data flows that are executed as part of a larger SQL Transformation project. Each transformation task is a logical transformation unit and can be translated into a complete SQL statement or script. A Task Group allows you to execute all tasks together as one transaction, or in individual transactions.
Generic SQL
Custom SQL
Critical task – terminate a transformation project immediately in case of a failure. The Critical Task property applies to individual tasks.
Single transaction – execute all tasks in a Task Group together as one transaction , or in individual transactions . This option is applicable only when project level transaction is not selected. It applies to the Task Group
When Single transaction is not selected, each task in the group is executed in its own transaction, thus individually committed or rolled back. If a task flagged as Critical fails the project is aborted. The Continue on error property does not have any effect.
When Single transaction is selected, a failure of any task in the group rolls back the transaction and finishes execution of the group. In this case, the Critical task option has no effect.
Continue on error – continues project execution even if an error occurs when executing non-critical tasks contained in the Task Group. This property applies to the Task Group.
A Task Group has a single input port that accepts multiple connections from Start, Task Group, and Decision components. It has a single output port supporting a single connection to a Task Group, Decision, Error, or Finish component.