How to: Set Container Properties

Many container properties can be set in the Properties window. The exceptions are the properties that are complex. For example, you cannot configure the enumerator that the Foreach Loop container uses in the Properties window. Use a custom editor to set these properties. Most container editors have multiple nodes and each node contains related properties. The name of the node indicates the subject of the properties that the node contains.

To set container properties in the Properties window

  1. In Business Intelligence Development Studio, open the project that contains the Integration Services package you want.

  2. In Solution Explorer, double-click the package to open it.

  3. Click the Control Flow tab.

  4. On the design surface of the Control Flow tab, right-click the container, and then click Properties.

  5. In the Properties window, update the property value.

  6. Optionally, create property expressions for the properties of the container. For more information, see How to: Create a Property Expression.

  7. To save the updated package, click Save Selected Items on the File menu.

To set container properties using a container editor

  1. In Business Intelligence Development Studio, open the Integration Services project that contains the package you want to configure.

  2. In Solution Explorer, double-click the package to open it.

  3. Click the Control Flow tab.

  4. On the design surface of the Control Flow tab, double-click the container to open its editor.

    For information about configuring the For Loop container, see How to: Configure a For Loop Container.

    For information about configuring the Foreach Loop container, see How to: Configure a Foreach Loop Container.

    Note

    The Sequence container has no custom editor.

  5. To save the updated package, click Save Selected Items on the File menu.

See Also

Concepts

Integration Services Containers
Control Flow How-to Topics (SSIS)

Help and Information

Getting SQL Server 2005 Assistance