Export (0) Print
Expand All
Expand Minimize
0 out of 1 rated this helpful - Rate this topic

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.

    ms140164.note(en-US,SQL.90).gifNote:
    Many properties are read-only, and cannot be modified.

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

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.