Loading Data at Input Port to a Database or a Text File

Use the Flush Buffer option to write 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 appears, along with the number of rows. If the buffer is empty, the option is not available.
Right-click the Text Data Sink component and select Flush Buffer.