United States (English)

Home Library Learn Samples Downloads Support Community Forums

MSDN Library

Servers and Enterprise Development

SQL Server

SQL Server 2012

Product Documentation

Books Online for SQL Server 2012

Integration Services

Integration Services Features and Tasks

Integration Services (SSIS) Packages

Control Flow

Integration Services Containers

Foreach Loop Container

Configure a Foreach Loop Container

Loop through Excel Files and Tables by Using a Foreach Loop Container

Add Enumeration to a Control Flow

For Each Item Columns Dialog Box UI Reference

Foreach Loop Editor (General Page)

Foreach Loop Editor (Collection Page)

Foreach Loop Editor (Variable Mappings Page)

Select SMO Enumeration Dialog Box

Schema Restrictions Dialog Box

Minimize

0 out of 4 rated this helpful - Rate this topic

Schema Restrictions Dialog Box

SQL Server 2012

Use the Schema Restrictions dialog box to set the schema restrictions to apply to the Foreach ADO.NET Schema Rowset enumerator.

Restrictions

Select the constraints to apply to the schema.

Variable

Use a variable to define restrictions. Select a variable in the list, or click New variable... to create a new variable.

Related Topics: Integration Services (SSIS) Variables, Add Variable

Text

Provide the text to define restrictions.

Reference

Foreach Loop Editor (Collection Page)

Concepts

Foreach Loop Container

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

© 2013 Microsoft. All rights reserved.