Text Data Sink properties list

Text Destination

Specify the output file. Text Data Sink prompts you for the destination file when you add the component to the project. To specify a destination file, click the Destination File icon in the from the Properties window, and select an existing file, or type the full path and file name to create one during project execution.

Columns

Click the Columns icon to define columns for data in the source file. If the Property value is not empty, the Columns value reflects the port structure or attribute values you defined on the Component window.

Row Delimiter

Select how each row is delimited:

• Position (fixed line position)

• LF (Line feed)

• CR (Carriage return)

• CRLF (Carriage return followed by a line feed)

Alternatively, you can enter a different delimiter.

Row Length

Specify the number of characters in each fixed row, if you have selected Position as the Row Delimiter.

Column Delimiter

Select how column are delimited:

• Position (fixed column positions)

• Tab

• Comma

• Semicolon

Alternatively, you can enter a different delimiter.

Column Quote

Specify how you want the values in the output file to be quoted (delimited files only):

• None

• Single quote

• Double quote

Fixed by Bytes

Specify how to interpret the values provided for line length, column start, and column end:

• Not selected – the values are interpreted as number of characters. This is the default.

• Selected – the values are interpreted as number of bytes.

For example – Suppose your source file includes binary: 0x61 62 63 d6 d0 ce c4 61 62 63 64 65 and has the following characteristics:

• File Type – Fixed (Variable Line)

• Encoding – GB2312

• Row delimiter – '\n'

• Column definition – column1: 1-7; column 2: 9-10

If you select the Fixed by Bytes option:

• Column 1 displays the first 7 bytes, the binary of which are, 0x61 62 63 d6 d0 ce c4.

• Column 2 displays the 9th and 10th bytes, the binary of which are, 0x62 63.

If you do not select the Fixed by Bytes option:

• Column 1 displays the first 7 characters, the binary of which are, 0x61 62 63 d6d0 cec4 61 62.

• Column 2 displays the next 2 characters, the binary of which are, 0x64 65.

Encoding

Select an appropriate value from the drop-down menu to set the current character encoding.

Column Header

Select the option to write the column names to the file.

Header

Click the Header icon to create a report header to write to the file. Text Data Sink writes the header before it writes the incoming data. This is an optional output property.

Type the header text for a header you want to write. Expressions are allowed in Square Bracket Notation.

Append Data

Select the option to append incoming data to the destination file. If you do not set this value, Text Data Sink overwrites any existing data in the destination file.

Write Block Size

Specify the number of records that Sybase ETL writes to the file in a single write operation.