You are here:

Block Until Done Tool

The Block Until Done tool stops data sets from moving downstream until the last record in the set has been processed by all previous tools. In addition, this tool ensures that only a single output stream receives the completed data set. Subsequent streams are blocked until all the data set records are pushed through the first stream.

Configure and Use the Tool

You do not need to configure the Block Until Done tool. Place the tool at the workflow location where you want to sequence various sets of data. The workflow executes the data sets in the order defined by the Block Until Done tool's output anchors.

You can use the tool in the following scenarios:

When reading and writing to the same file, use the Block Until Done tool to ensure the entire file is read before being written to.
When writing to an Excel file, you can use the tool to write only to one sheet at a time, preventing write errors.

Keep in mind that the Block Until Done tool can slow down execution because it requires a large amount of memory.