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

Data Source

List of available data sources.

Caching

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

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.

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

Iterator Break

Iterator Continue