The dynamic schema columns are easy to define. To define dynamic
columns for the Databases
Input and Output components, or for tFileInputDelimited and tFileOutputDelimited.
Procedure
-
In the component's Basic
settings tab, set the Property
Type as Built-In.
Warning: 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.
Warning: In the Database Input components, the SELECT
query must include the * wildcard, to
retrieve all of the columns from the table selected.
-
Click the Type field and
then the arrow which appears to select Dynamic
from the list.