Using Variables with SQL Statements

Cycle variables can be used with SQL statements. Using Cycle variables allows you to build dynamic SQL statements and to pass data into the commands. After a SQL statement is executed, the following Step lets you save a value from the SQL result set for later use:

I assign row < ROW_NUMBER > column "< COLUMN_NAME >" to variable "< VARIABLE_NAME >"