About
Data profiling capabilities
Articles Related
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.
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.
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,
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.)