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) End of line: The line break used in the destination file.

(5) Each record is a row: If this checkbox is set, each row created here is written as one row in the destination file. Otherwise, the length of a row created here must be specified and (4) is omitted.

(6) Indices: Specifies the indices (starting at 0) from which the individual fields are written. A tool for this is available via (7).

(7) Magic wand icon: See (6).

(8) Add header row: This allows a header to be added with a wizard. Note: If a dynamic path/filename (1) is used and the checkbox Release resources created for further processing in the source data 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 Fix record (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) Test output/settings: Here the ETL/ELT source fields can be filled with test data to test the output.

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