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.


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

Comments (1)
  1. ETL vs ELTL says:

    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

Comments are closed.

Skip to main content