Package

Package combines various actions together. Every package has a starting point. Package actions executed sequentially starting from the starting point. Package action execution status can be success of failure. Depending of execution status next action is executed.

Basic Package

Action Execution

Action execution consist of three stages

1 Preparation

Action parameters are calculated and variables are replaced with actual values

Package Action Preparation

2 Execution

3 Assigning variables selected on after execution tab

After execution tab

Package Example

Package Example

Creating New Package

  • To create a new Package select a Package group from the objects tree and click New
  • Dialog box will appear
  • Fill in the Description edit box with the name of the Package you are about to create
  • Fill in a comment if required
  • Click OK to finish the creation of the Package
Package Action Variables

Package Screen Overview

Every package must have a starting point (Action on the left of the picture). Action execution state defines which action is executed next. The Blue line is a success and the Orange Line is a failure.

Package Screen Overview

Setting Starting Point

Setting Starting Point

Joining Actions

Objects can be joined to other objects as shown here. This is achieved by simple “drag” and “drop” of the items from one to another. To remove the link repeat the process.

Joining Actions

Catch All Actions

Catch-All Actions provide a way of reducing the complexity of a package

Catch All Actions

On Error

On Error

On Success

On Success

Package Tool bar

The package toolbar provides all the tools you need in order to create and manipulate objects. It is also possible to change how objects are viewed in the interface.

Package Tool bar
  1. Packages Properties
  2. Open Package from file
  3. Save Package to file
  4. Save to the Repository
  5. Print
  6. Print Preview
  7. Cut
  8. Copy
  9. Paste
  10. Delete selected Action(s)
  11. Clear all
  12. Undo
  13. Redo
  14. Search
  15. Align Left
  16. Arrange Vertically
  17. Align Right
  18. Align Bottom
  19. Arrange Horizontally
  20. Align Top
  21. Space Horizontally
  22. Space Vertically
  23. Snap to grid/show grid
  24. Manage Versions
  25. Add Version
  26. Revert to previous version
  27. Make Package Read Only
  28. Show/Hide execution log
  29. Open execution log directory
  30. Schedule Package for Execution
  31. View Execution Log (When executed by agent/scheduler)
  32. Debug package
  33. Continue execution
  34. Execute Package using agent/Integrated Scheduler
  35. Stop package execution
  36. Zoom In
  37. Zoom Out
  38. Zoom back to 100%

Automatic Version Control

Every time the user presses the save button package is automatically added to the version control

Notes Dialogue

Notes Dialogue

Video Tutorial

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

Confused? Ask question on our ETL Forum
Last updated: September 17, 2022