Settings

(1) File name with absolute path: The path and name of the destination file to be created. Paths below the installation directory of the Integration Server can be specified relatively with ./ Note: Variables, see (3), and placeholders, see tooltip, can be used.

(2) Icon right of (1): Displays the destination file.

(3) Icon right of (2): Selection of ETL/ELT variables.

(4) Null value: The replacement value for destination fields without value.

(5) Separator: The column separator to be used in the destination file.

(6) Q uoting : The quoting character to be used in the destination file.

(7) End of line: The line break to be used in the destination file.

(8) Add header row: This allows a header to be added with a wizard (appears when the checkbox is set). Note: If a dynamic path/filename (1) is used and the checkbox Release resources created for further processing is set, then headers cannot be used.

(9) Source field: ETL/ELT source fields and custom ETL/ELT fields can be selected here.

(10) Source field: Index columns ($COL.1, $COL.2, etc.) can be selected here. See section CSV/Text (source ETL/ELT).

(11) Source field: ETL/ELT variables can be selected here.

(12) Arrow in the middle: With this you can move selected data items (9), (10) and (11) to the right (13). With the symbol above, entries selected on the left can be assigned to existing entries on the right in order. Drag and drop is also possible.

(13) Columns/Values: The structure of the row to be generated. See section Examples (ETL/ELT).

(14) Read and display row: Fills the columns given in (13) with values on a test basis (based on destination file).

(15) Test output/settings:Here the ETL/ELT source fields can be filled with test data to test the output.

(16) Miscellaneous ETL driver settings: This is an expert setting (Scriptella) and can be ignored.