Drag the Text Data Sink component onto the Design window.
The OUT-port of Text Data Sink should link to the IN-port of the component that provides the inbound data when you add the component to the project.
See the “Text Data Sink properties list” for specific field requirements. Also see:
Exporting and importing file definitions – export and import options on the Component window let you save the file properties to a definition file, and reuse them for other components.
Modifying the port structure (delimited files)– column values for delimited files reflect the current IN-port structure. You can assign a port structure based on another port or recreate the current port structure.
Working with fixed length files – if you work with fixed-length file types, you must create the columns, and provide the position parameters for each column.
Click Save.
Specify any other optional properties in the Properties window.
If there is an adjacent component available in the Design
window, Sybase ETL automatically creates a link between the Text
Data Sink IN-port with the OUT-port of that component. For delimited
files, this link provides the initial port structure you see when
the window opens.
If not, you may need to close the Design window and connect the Text Data Sink IN-port with the OUT-port of an adjacent component.
Text Data Sink does not impact the simulation sequence.
To load data currently available at the input port to a database or a text file:
Right-click the Text Data Sink component.
Select Flush Buffer.
The Flush Buffer option writes out the buffered rows to the target. All components for which a write block size has been specified, can buffer data until the write block size is reached. At any time during simulation, if there is data in the buffer, the Flush Buffer option will display along with the number of rows. If the buffer is empty, the option will be grayed out.
Loading data at input port