Melissa Data is proud to introduce our new Profiler component in Data Quality Components for SQL Server Integration Services (SSIS). The addition of this new Profiler component allows users to quickly profile their data set for analysis in an easy-to-use GUI-based ETL environment.
Simply map in the columns that you want to be profiled and set the options for profiling. The Profiler component will output different types of data analysis and also output a complete PRF file which can be analyzed in a SQL-Lite browser.
Here is a preview of the interface for the new Profiler component for SSIS.
Analysis options tab:
Output settings tab:
Sample SQL-Lite Analysis DB Generated by Profiler Component: