How do you perform data profile in SQL Server Integration Services? What are the different kinds of data profiling in SSIS?

Analyzing the data quality has been a challenge for SSIS developers. The SQL Server development team understands this challenge and provided a new Data Profile Task in SQL Server 2008.

You can use this task for profiling data during the process of extraction, transformation and loading of data. This new task allows you to save the profile result as XML in an SSIS variable or in a file. The SQL Server development team also provided a Data Profiler Viewer tool which is used to analyze collected profile data. 

The Data Profiling Task allows you to profile data in eight different profiles. Five of these profiles analyze individual columns and the remaining three profiles analyze multiple columns or relationships between columns and tables.