How to reference a parameter in a SQL Server source step

Illustrated below is an example of a Buffer as a source step, a Calculator step and SQL Server as a source step in a sub-flow. In this example, the data in the buffer are table names that will be used in the SQL Server source step.

The below image is the code in the Calculator step before the sub-flow; where a record (BufferName aka SQL Server table name) from the buffer source is converted to a parameter.

image

In the below image, ‘{@TableName}’ is used in the SQL query to reference the parameter and use the selected value/ SQL table name. At the bottom of the step in the Input Parameters section, the TableName parameter is referenced with the field it’s pulling the value from (BufferName).

image

image