Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Expand Minimize

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

SQL Server 2005

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.

  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.

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

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

Community Additions

© 2015 Microsoft