Data Profiling task in SSIS (SQL Server Integration Services ) 2008

In SQL Server 2008, SSIS introduces the Data Profiling task in its toolbox, which provides data profiling functionality inside the process of extracting, transforming, and loading data. By using the Data Profiling task, you can analyze the source data more effectively, understand the source data better, and prevent data quality problems before they are introduced into the data warehouse.

Refer this link for more details.

https://www.sql-server-performance.com/articles/biz/SSIS_New_Features_in_SQL_Server_2008_Part3_p1.aspx

Comments

• Anonymous
  April 14, 2011
  you would like to see the example for this task. Please check Jamie's Blog..consultingblogs.emc.com/.../ssis-data-profiling-task-part-1-introduction.aspx