Packages

This chapter describes Packages - a great way of combining different Actions together. Most of the actions are self-explanatory therefore only screenshots provided.

• Transformation (Advanced ETL Processor Only)
• Import
• SQL Data check
• SQL Script
• Package
• FTP Operation
• HTTP Download
• ZIP Operation
• Receive Email POP3
• Receive Email IMAP4
• Send Email
• External Application
• Check File
• File operation
• Compare Files
• Check Disk Space
• Backup Repository
• Clear Log
• Pause
• Check Date
• Report
• Export Data
• Show Message
• Ask Question
• Set Variable
• Script
• Check Connection
• Ping Server
• Case
• Gpg4win
• HTTP Form
• Soap
• SMS Messaging
• Twitter
• Loops
• Publishing Tableau Files
• Amazon S3 Action
• Azure Blob Action
• Cloud storage operations
• Change File Encoding
• Telegram messaging
• Check License Action
• Extract MIME Data

We are constantly working on improving our software if some of the functionality is missing please post your suggestions on our ETL Forum and we will be more than happy to add it.

• 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

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.

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.

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

On Error

On Success

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.

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

• Advanced ETL Processor Professional and Enterprise Documentation
• Visual Importer ETL Professional and Enterprise Documentation