Package

A Package is a container that combines multiple actions into a single automation workflow. Each package has a defined starting point from which execution begins.

Each action performs a specific task, such as copying a file, executing a SQL statement, running a transformation, or sending an email.

After an action is executed, it returns one of the following statuses:

  • Success — the action completed successfully.
  • Failure — the action failed or a specified condition was not met.
  • Loop End — the current loop has completed.

The execution status determines which action is executed next. This allows packages to implement conditional logic, branching, loops, and error-handling paths.

By combining multiple actions and controlling the execution flow between them, Packages can automate simple tasks as well as complex, multi-step business processes.

Package Example

Basic Package

Creating a Package

  1. Select a Package Group in the Objects Tree and click New.
  2. Enter the name of the Package in the Description field.
  3. Optionally, enter a Comment to provide additional information about the Package.
  4. Click OK to create 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 August 30, 2026 • 2 min read • 418 words
www.etl-tools.com About Support Pricing Cookies Policy Term Of Use Privacy Policy License