Data profiling is the process of examining, analyzing, and creating useful summaries of data. The process yields a high-level overview which aids in the discovery of data quality issues, risks, and overall trends. Data profiling produces critical insights into data that companies can then leverage to their advantage.
How do I use SQL data Profile Viewer?
- Right-click the Data Profiling task in the SSIS Designer, and then click Edit. Click Open Profile Viewer on the General page of the Data Profiling Task Editor.
- In the folder, <drive>:\Program Files (x86) | Program Files\Microsoft SQL Server\110\DTS\Binn, run DataProfileViewer.exe.
What is data viewer in SSIS?
SQL Server Integration Services (SSIS) provided Data Viewer in Data Flow Task. Data Viewer can be used between two transformations to see the data. When we executes our package Data Viewer pop up window shows data so we can see What is changed from Input to Output.
