Export (0) Print
Expand All
0 out of 3 rated this helpful - Rate this topic

How to: Set Container Properties

SQL Server 2005

Updated: 17 July 2006

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.

  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.

  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.

    ms141726.note(en-US,SQL.90).gifNote:
    The Sequence container has no custom editor.

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

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.