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

This topic describes how you set the properties of data flow components which include sources, destinations, and transformations, using the Advanced Editor dialog box. The Advanced Editor dialog box provides access to custom properties for each component, as well as the properties common to all data flow components, the properties of inputs, outputs, error outputs, columns, and external columns.

  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 you want to view or modify.

  4. In the data flow designer, right-click the data flow component, and then click Show Advanced Editor.

    In SQL Server 2005, data flow components that support multiple inputs cannot use the Advanced Editor.

  5. In the Advanced Editor dialog box, do one of the following:

    • Click the Connection Managers tab to view and specify the connection that the component uses.
      The Connection Managers tab is available only to data flow components that use connection managers to connect to data sources such as files and databases

    • Click the Component Properties tab to view and modify component-level properties.
    • Click the Column Mappings tab to view and modify mappings between external columns and the available output.
      The Column Mappings tab is available only when viewing or editing sources or destinations. For more information, see Integration Services Sources and Integration Services Destinations.

    • Click the Input Columns tab to view a list of the available input columns and to update the names of output columns.
      The Input Columns tab is available only when working with transformations or destinations. For more information, see Integration Services Transformations.

    • Click the Input and Output Properties tab to view and modify the properties of inputs, outputs, and error outputs, and the properties of the columns they contain.
      Sources have no inputs. Destinations have no outputs, except for an optional error output.

  6. View or modify the property values.

  7. Click OK.

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