Jamie Thomson has posted a great series on the SSIS 2008 Data Profiling Task.
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, and functional dependencies. You can learn more in Jamie's series or at MSDN.
One very cool feature is the ability to set up a Single Table Quick Profile to quickly configure and capture desired statistical data.
Once you capture the data, you use a separate stand-alone tool for viewing the results: the Data Profile Viewer.
SQL Server 2008 CTP6 (February 2008) includes a functioning version of the Data Profiling Task in SSIS 2008.
:{> Andy
Comment Notification
If you would like to receive an email when updates are made to this post, please register here
Subscribe to this post's comments using
About andyleonard
Andy Leonard is a SQL Server MVP, Solid Quality Mentor, database developer, engineer, husband, and father. At the time of this writing (August 2007) Andy lives in Farmville, Virginia with his lovely bride Christy Lynn and their three children: Stevie Ray, Emma Grace, and Riley Cooper. Andy's two older children - Manda and Penny - are grown and married. When he's not working (and Andy works a lot), he enjoys spending time with his family, working on their old farmhouse, fishing, and reading older sci-fi series.