SSIS - Data Profiling

About

Data profiling capabilities

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.)

Stand-alone viewer


Powered by ComboStrap