CSV/Text (destination ETL/ELT)

(1) 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) Displays the destination file.

(3) Selection of ETL/ELT variables.

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

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

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

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

(8)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) ETL/ELT source fields and custom ETL/ELT fields can be selected here.

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

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

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

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

(14) Fills the columns given in (13) with values on a test basis (based on destination file).

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

(16) This is an expert setting (Scriptella) and can be ignored.