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 ETL Forum and we will be more than happy to add it.

• To create a new Package select a Package group from objects tree and click New
• Dialog box will appear
• Fill in 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

The package screen overview provides the user with the ability to create objects. The objects are numerous and can be combined with any number of other objects. For instance, you can combine an SQL script to output information to an email and vice versa, to store information from an email into a database. There is a great deal of flexibility in the system.

Every package must have a starting point (Action on the left on the picture).

Starting Point

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. It is a very simple 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. Zoom In
36. Zoom Out
37. Zoom back to 100%

Automatic Version Control

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

Video Tutorial

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