http://sqlblog.com/blogs/andy_leonard/archive/tags/SQL+Server+2008/Data+Profiing+Task/default.aspxTags: SQL Server 2008, Data Profiing TaskenCommunityServer 2.1 SP2 (Build: 61129.1)http://sqlblog.com/blogs/andy_leonard/archive/2008/03/13/ssis-2008-data-profiling-task.aspxThu, 13 Mar 2008 03:01:00 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:5551andyleonard4http://sqlblog.com/blogs/andy_leonard/comments/5551.aspxhttp://sqlblog.com/blogs/andy_leonard/commentrss.aspx?PostID=5551<P><A class="" href="http://blogs.conchango.com/jamiethomson/default.aspx" target=_blank>Jamie Thomson</A> has posted a great series on the <A class="" href="http://blogs.conchango.com/tags/SQL+Server+Integration+Services/Data+Profiling/default.aspx" target=_blank>SSIS 2008 Data Profiling Task</A>.</P> <P>The Data Profiling Task allows developers to quickly assess key statistics about data in a database table. When I say "statistics" I mean things like column value and length distribution, column null ratio, column patterns,&nbsp;and&nbsp;functional dependencies. You can learn more in Jamie's series or at <A class="" href="http://msdn2.microsoft.com/en-us/library/bb895322(SQL.100).aspx" target=_blank>MSDN</A>.</P> <P>One very cool feature is the ability to set up a <A class="" href="http://msdn2.microsoft.com/en-us/library/bb934046(SQL.100).aspx" target=_blank>Single Table Quick Profile</A>&nbsp;to quickly configure and capture desired statistical data.</P> <P>Once you capture the data, you use a separate stand-alone tool for viewing the results: the <A class="" href="http://msdn2.microsoft.com/en-us/library/bb895313(SQL.100).aspx" target=_blank>Data Profile Viewer</A>.</P> <P>SQL Server 2008 CTP6 (February 2008) includes a functioning version of the Data Profiling Task in SSIS 2008. </P> <P>:{&gt; Andy</P><img src="http://sqlblog.com/aggbug.aspx?PostID=5551" width="1" height="1">Business IntelligenceData Profiing Taskdatabase developersSQL Server 2008SSIS