Jaa


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

You can set the properties of data flow components, which include sources, destinations, and transformations, by using the component editors that Microsoft SQL Server 2005 Integration Services (SSIS) provides.

The component editors include only the custom properties of each data flow component. For information about setting the properties of inputs and outputs, columns, and standard properties of data flow components, 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 data flow with the component whose properties you want to view and modify.

  4. Double-click the data flow component.

  5. In the component editor, view or modify the property values, and then close the editor.

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

See Also

Tasks

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

Concepts

Integration Services Transformations
Data Flow How-to Topics (SSIS)

Other Resources

Integration Services Sources
Integration Services Destinations

Help and Information

Getting SQL Server 2005 Assistance