Iterate Output Object

The Integrator Iterate output object defines an object in Integrator to call and iterate other tasks or task lists, varying parameters based on columns in the input flow. For each row of the input data flow, it executes an Integrator task or task list, setting the DI object language parameters based on the data flow columns. It is similar to the Execrows output object except it runs Integrator tasks instead of executing an external command.

Iterate Attributes

Attribute	Type	Description
output_type (required)	String	Identifies the object as an Iterate output object. The string value is "iterate".
input (required)	String	Defines the object from which the data flow is arriving.
parameters (required)	Array of Strings	Defines the columns that will be used to set parameter values for the given task or task list. The column name must match the parameter names defined in the PARM object.
task	String	Defines the name of a task (TASK object) that will be executed once for each row in the input flow. This attribute conflicts with the task_list attribute. task and task_list are mutually exclusive attributes but one or the other must be defined.
task_list	String	Defines the name of a task list (TSKL object) containing any number of tasks that will be executed once for each row in the input flow. task_list and task are mutually exclusive attributes but one or the other must be defined.
error_action	String	Defines the action to be taken if an error occurs when running the given task or task list. Actions include: continue—Integrator continues running the specified task with the next set of parameters. (default) exit—Integrator stops iterating and returns an error if the specified task encounters a error.
trace_before	Sub-object	Traces data flows entering the specified object. This is equivalent to adding the Trace process object immediately before the current output object. See Embedded Trace Object.