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:
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.
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