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
Comments