In the component's Basic settings tab, set the
Property Type as Built-In.
The dynamic schema is only supported in Built-In mode.
Click Edit schema to define the schema.
The [Schema] dialog box opens.
- In the last row added to the schema, enter a name for the dynamic column in the Column field.
- Click the Type field and then the arrow which appears to select Dynamic from the list.
The dynamic column must be defined in the last row of the schema.
In the Database Input components, the SELECT query must include the * wildcard, to retrieve all of the columns from the table selected.
For further information regarding the mapping of dynamic columns, see Mapping dynamic columns.