The Loop Dataset action is used to loop through the rows of a dataset and execute a step or series of steps for each record. The dataset must be created in an earlier step using an SQL Query action or a Cells to Dataset action.
When you create a Loop Dataset step, an End Loop step is created automatically. Place the steps to be performed between the Loop Dataset step and the End Loop step. The steps within the block should be indented for visual clarity.
From the Task Builder Available Actions pane, open the Loop folder and double-click the Loop Dataset action or drag it into the Steps pane.
In the Dataset name box, select the dataset.
If you want to specify a series of rows to be looped, select Optional parameters, and enter a start row and an end row. If this is not selected all rows are looped.
If you want to loop the records in an alphabetical sort order other than what exists in the dataset, click the Advanced tab and enter the properties as follows:
In the Output list box, select the sort order.
In the Column to sort on box, select the column of the dataset to use.
To set the Description tab properties, refer to Description Tab Options.
To set the Error Causes and On Error tab properties, refer to Step Error Handling.
When finished, click OK to save settings and close the properties dialog window.
In the Task Builder Steps pane, hold down SHIFT and click the first and last steps in the block so that the complete block of steps is selected.
Click the Format button .
Adding Task Steps
Loop Dataset Action