A Package serves as a container that combines multiple actions into a cohesive workflow. Each package has a designated starting point, from which the sequence of actions begins. The actions within the package are executed sequentially, following the defined order of operations.
The execution of each package action produces a status, which can be one of the following: success, failure, or loop end. Based on this status, the package dynamically determines the next action to execute, enabling conditional logic and decision-making within the workflow.
This design ensures flexibility and control, allowing for complex workflows that can handle branching, retries, and iterative processes. Packages are ideal for automating tasks that involve multiple interconnected actions, improving efficiency and consistency in process execution.
Most actions have a single starting point, along with one On Success point and one On Error point. Additionally, Loop Actions include an On Loop End point, while Case Actions may have multiple On Success points.
Actions can be connected to other actions seamlessly, as demonstrated here. This is accomplished by simply dragging and dropping one item onto another.
To remove a link, repeat the drag-and-drop process or double click on the starting point
Catch-All Actions simplify package design by reducing its overall complexity.
Execution Result is determined during the action’s execution but can also be manually set to either success or failure.
The Execution Result is determined by the outcome of the last executed action but can also be manually set to success or failure.
For more technologies supported by our ETL Software see Advanced ETL Processor Versions
Confused? Ask question on our ETL Forum