The Options dialog in Advanced ETL Processor controls repository connections, execution settings, interface behaviour, email defaults, notifications, and global variables. Check these settings before automation work, because defaults are only friendly until production depends on them.
What You Will Learn
- Open the Options dialog from the System Menu.
- Review repository connection settings before changing environments.
- Set execution, logging, email, and notification defaults for repeatable runs.
- Use global variables when shared values need to be managed in one place.
Before You Start
Record the current settings before changing them. Screenshot-driven change control is not glamorous, but neither is guessing which checkbox broke Monday morning.
Options Dialog Docs
The Options documentation explains how to open the dialog from System Menu -> File -> Options and what each tab controls.
Start with the Repository tab if you are changing repository connections. The repository stores connections, transformations, packages, SQL scripts, reports, and execution logs, so a small repository change can have a large blast radius.
For production defaults, review the Execution tab, Email tab, and Notifications tab. These settings affect logging, package execution, default email behaviour, Agent failure alerts, and package notifications.
The Global Variables tab is useful when SQL, packages, or transformations need shared values. Also check the Options notes for where settings are stored under C:\ProgramData\ETL-Tools.com.
Need Advanced ETL Processor First?
Download the Advanced ETL Processor trial before following the tutorial, or review Enterprise if you need scheduled unattended execution.