SSIS - Data Profiling
Table of Contents
1 - About
Data profiling capabilities
2 - Articles Related
3 - Process
The Data Profiling task gathers the requested profile statistics and writes them to an XML document.
This can be:
- saved as a file for later analysis,
- or written to a variable for programmatic analysis within the SSIS control flow.
3.1 - Create the data profile request
- Create an SSIS (Integration Service) project that includes a package.
- Add an ADO.NET connection manager for each data source that you want to profile.
- Add the Data Profiling task to the control flow of the package.
- Configure the Data Profiling task to specify:
- The file or variable to which the resulting profile statistic should be written.
- The individual profile requests that should be included in the report.
3.2 - Run it and view the results
The viewer is available:
- in Debug Mode: in SQL Server Data Tools from the Properties dialog box of the Data Profiling task while the package is running in the development environment.
- as a stand-alone tool. Where you can open the result file (XML) that the Data Profiling task generates,
3.2.1 - Debug Mode
- Run the package in debugging mode.
- View the resulting profile statistics in the Data Profile Viewer. (When the Data Profiling task has completed, with the package still running, double-click the Data Profiling task, and then click Open Profile Viewer.)