How to: Set Task Properties

  • Article

Most task properties can be set using the Properties window. The exceptions are properties of task collections and properties that are too complex to set using the Properties window. Use a task editor to set these properties. Most task 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 task properties in the Properties window

  1. In Business Intelligence Development Studio, open the Integration Services project that contains the 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 task, and then click Properties.

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

    Note

    Most properties can be set by typing a value directly in the text box, or by selecting a value from a list. However, some properties are more complex and have a custom property editor. To set the property, click in the text box, and then click the build (…) button to open the custom editor.

  6. Optionally, create property expressions to dynamically update the properties of the task. 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 task properties by using a task editor

  1. In Business Intelligence Development Studio, open the Integration Services project that contains the 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 task, and then click Edit on the context menu to open the task editor.

  5. If the task editor has multiple nodes, click the node that contains the property you want to set.

  6. Optionally, click Expressions and, on the Expressions page, create property expressions to dynamically update the properties of the task. For more information, see How to: Create a Property Expression.

  7. Update the property value.

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

See Also

Concepts

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

Help and Information

Getting SQL Server 2005 Assistance