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


Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.