This tutorial shows how to use the Select Value action in Advanced ETL Processor. It retrieves one value from a list and stores it in a variable, which is handy when testing SQL, lookups, and branch conditions before the package becomes fully automatic.
What You Will Learn
- Configure a Select Value action in a package workflow.
- Choose a database connection and SQL script or lookup source.
- Store the selected value in a package variable.
- Use embedded SQL when a small query belongs directly in the action.
Before You Start
Use a test repository or safe sample data while following the tutorial. Production jobs are a poor place to experiment.
Select Value Action Docs
This tutorial uses the Select Value action to retrieve a single value and assign it to a variable. In practice, it is useful when you need to test a lookup, confirm a control value, or inspect one row from a query without building the whole workflow around it.
The Select Value docs cover the parameters tab, selecting a connection, selecting a source script or lookup, variables tab, and execution log tab.
Related interactive actions include Ask Question Action, Show Message Action, and User Input Action. For troubleshooting, also review debugging actions and working with variables.
Need Advanced ETL Processor First?
Download the Advanced ETL Processor trial before following the tutorial, or review Enterprise if you need scheduled unattended execution.