Workflows are where individual ETL steps become automation. Use packages to run transformations, move files, check conditions, send messages, and control execution order without turning the whole job into a ball of string.
What You Will Learn
- Create a package workflow in Advanced ETL Processor.
- Set the package starting point.
- Link actions into a repeatable process.
- Use success and error paths before scheduling unattended execution.
Before You Start
Build and test individual transformations before adding them to a workflow. Debugging five untested steps at once is technically possible, but rarely character building in a useful way.
Package Docs For Workflow Automation
Packages are the workflow layer in Advanced ETL Processor. They connect actions, define what runs first, and decide what happens after success or failure. In practice, this is where a collection of useful ETL steps becomes an automated job instead of a folder full of good intentions.
The package documentation covers creating a new package, the package screen overview, setting the starting point, and linking actions.
Before scheduling a workflow, also review catch-all actions, default error paths, action execution results, and package execution results.
Need Advanced ETL Processor First?
Download the Advanced ETL Processor trial before following the tutorial, or review Enterprise if you need scheduled unattended execution.