On channel 9 there is a video on Microsoft SQL Server Integration Services 2008 and data profiling. SSIS 2008 contains a data profiling task, it allows you to automatically analyze you’re data:
> Is the data in this column unique?
> What is the percentage of null values in this column?
> Create regular expressions for new validation rules in de UI
> Column statistics on numeric columns, like min value, max value, standard deviation
> Number of distinct values and what these values are