Package

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.

Package Example

Basic Package

Creating a New Package

  • Select a Package group from the objects tree and click New.
  • Enter the name of the Package in the Description field.
  • Optionally, add a comment if needed.
  • Click OK to complete the creation of the Package.
Package Properties

Package Screen Overview

Package Screen Overview

Action types

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.

Action types

Setting Starting Point

Setting Starting Point

Linking Actions

Actions can be connected to other actions seamlessly, as demonstrated here. This is accomplished by simply dragging and dropping one item onto another.

Linking Actions

To remove a link, repeat the drag-and-drop process or double click on the starting point

Removing Links

Catch All Actions

Catch-All Actions simplify package design by reducing its overall complexity.

Catch All Action

Default Error

On Error

Default Success

On Success

Action Execution Result

Execution Result is determined during the action’s execution but can also be manually set to either success or failure.

Action Execution Result

Package Execution Result

The Execution Result is determined by the outcome of the last executed action but can also be manually set to success or failure.

Package Execution Result

Video Tutorial



For more technologies supported by our ETL Software see Advanced ETL Processor Versions

Confused? Ask question on our ETL Forum

Posted on January 15, 2025 • 2 min read • 408 words
www.etl-tools.com About Support Pricing Cookies Policy Term Of Use Privacy Policy License