How to: Set the Properties of a Data Flow Component in the Properties Window

This topic describes how to set the properties of data flow elements, which include sources, destinations, and transformations, by using the Properties window. The Properties window lists the component-level custom properties of each element, as well as the properties common to all data flow elements.

To set properties on inputs, outputs, and error outputs, or to set properties on specific columns, use the Advanced Editor. For more information, see How to: Set the Properties of a Data Flow Component Using the Advanced Editor.

To view and modify component properties

  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, and then double-click the Data Flow task that contains the component whose properties you want to view and modify.

  4. Right-click the data flow component, and then click Properties.

  5. View or modify the property values, and then close the Properties window.

    Note

    Many properties are read-only, and cannot be modified.

  6. To save the updated package view, click Save on the File menu.

See Also

Tasks

How to: Set the Properties of a Data Flow Component Using a Component Editor

Concepts

Data Flow Elements
Data Flow How-to Topics (SSIS)

Help and Information

Getting SQL Server 2005 Assistance