How to: Add a Data Viewer to a Data Flow

  • Article

This topic describes how to add and configure a data viewer in a data flow. A data viewer displays data that is moving between two data flow components. For example, a data viewer can display the data that is extracted from a data source before a transformation in the data flow modifies the data.

Before you can add data viewers to a package, the package must include a Data Flow task and at least two data flow components that are connected.

To add a data viewer to a data flow

  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, if it is not already active.

  4. Click the Data Flow task to whose data flow you want to attach a data viewer and then click the Data Flow tab.

  5. Right-click a path between two data flow components, and select Data Viewers.

  6. In the Data Flow Path Editor dialog box, click Data Viewers and then click Add.

  7. In the Configure Data Viewer dialog box, do one of the following:

    • Click Grid, click the Grid tab, and then select the columns you want to display in the data viewer. By default, all the available columns are selected and listed in the Displayed Columns list. Move columns that you do not want to use to the Unused Column list by selecting them and then clicking the left arrow.
    • Click Histogram, click the Histogram tab, and then select the column you want to model with the histogram. The histogram graph works only with numeric data and only with one column at a time.
    • Click Scatter Plot (x, y), click the Scatter Plot (x, y) tab, and then select a column for the X axis and a column for the Y axis in the scatter plot graph. The scatter plot graph works only with numeric data.
    • Click Column Chart, click the Column Chart tab, and then select the column you want to model in the column chart. The column chart graph works only with one column at a time.

  8. Click OK.

  9. Repeat step 7 to configure additional data viewers.

  10. Click OK.

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

See Also

Tasks

Debugging Data Flow

Concepts

Integration Services Transformations
Integration Services Paths
Creating Package Data Flow

Other Resources

Integration Services Sources
Integration Services Destinations
Debugging How-to Topics (SSIS)

Help and Information

Getting SQL Server 2005 Assistance