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 that are yet to be written to the target. If the buffer is empty, the option is not available.

Right-click the DB Data Sink Insert component and select Flush Buffer.