Executes a set of components for each record from SQL query.

Select Datasource

Open the datasource selection dialog.

Enter SQL expression

Set SQL request for work with a database. Template can be used in the request text.

Output Variables

Set the list of variables field values to be stored in.

Iteration Variable

Set variable name iteration number to be placed in.

---

Caching Tab

The description of the Caching Tab see in the article Caching in components working with data servers.

Remarks

To use this component, you must have Microsoft Data Access Components 2.5 or newer installed on your computer. For more details about MSDAC visit the Universal Data Access web-site.

See also

Database Access

Iterators