[This topic is pre-release documentation and is subject to change in future releases. Blank topics are included as placeholders.] Viewing and analyzing the data profiles is the next step in the data profiling process. You can view these profiles after you have run the Data Profiling task inside an Integration Services package and computed the data profiles. For more information about how to set up and run the Data Profiling tasks, see Setting Up the Data Profiling Task.
To view the data profiles, you configure the Data Profiling task to send its output to a file, and then you use the stand-alone Data Profile Viewer. To open the Data Profile Viewer, in the folder, C:\Program Files\Microsoft SQL Server\100\DTS\Binn, run DataProfileViewer.exe.
The viewer uses multiple panes to display the profiles that you requested and the computed results, with optional details and drilldown capability:
- Profiles pane
-
The Profiles pane displays the profiles that were requested in the Data Profile task. To view the computed results for the profile, select the profile in the Profiles pane and the results will appear in the other panes of the viewer.
- Results pane
-
The Results pane uses a single row to summarize the computed results of the profile. For example, if you request a Column Length Distribution Profile, this row includes the minimum and maximum length, and the row count. For most profiles, you can select this row in the Results pane to see additional detail in the optional Details pane.
- Details pane
-
For most profile types, the Details pane displays additional information about the profile results selected in the Results pane. For example, if you request a Column Length Distribution Profile, the Details pane displays each column length that was found. The pane also displays the number and percentage of rows in which the column value has that column length.
For the three profile types that are computed against more than one column (Candidate Key, Functional Dependency, and Value Inclusion), the Details pane displays violations of the expected relationship. For example, if you request a Candidate Key Profile, the Details pane displays duplicate values that violate the uniqueness of the candidate key.
If the data source that is used to compute the profile is available, you can double-click a row in the Details pane to see the matching rows of data in the Drilldown pane.
- Drilldown pane
-
If the data source that is used to compute the profile is available, you can double-click a row in the Details pane to see the matching rows of data in the Drilldown pane.
For more information about the user interface of the Data Profile Viewer, see Data Profile Viewer F1 Help.