Export (0) Print
Expand All
Expand Minimize

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.

  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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2015 Microsoft