Advanced ETL Processor can run ETL packages, transformations, SQL scripts, imports, reports, and block transformations from the command line by passing the object ID to aetlcl.exe. Use this when Windows Task Scheduler, batch files, or another automation tool needs to start ETL work directly.
What You Will Learn
- Run an Advanced ETL Processor object from the command line.
- Find the object ID for packages, transformations, SQL scripts, imports, reports, and block transformations.
- Use retry and timeout parameters when an automated run needs limits.
- Decide when the command line is a better fit than opening the desktop interface.
Before You Start
Test the command against a safe object first. A command line run does exactly what you asked, including the bit you typed before the second coffee.
Command Line Interface Docs
The Using Command Line Interface documentation shows the basic form: aetlcl.exe ID, where ID is the Advanced ETL Processor object you want to run.
The docs show how to find IDs for a package, transformation, SQL script, import script, report, and block transformation.
For unattended runs, review the optional retry count, hard timeout, and soft timeout parameters before wiring the command into another scheduler.
Need Advanced ETL Processor First?
Download the Advanced ETL Processor trial before following the tutorial, or review Enterprise if you need scheduled unattended execution.