Microsoft SQL Server Integration Services 2008 – Data Profiling, automatically analyze you’re data

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

Link
http://channel9.msdn.com/shows/toolshed/ToolShed-Tooltip-20-SSIS-Data-Profiling-saves-your-eyeballs/

Leave a Reply

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