SQL Server 2008 Integration Services ships with the wonderful new Data Profiling Task. Much as the name implies, it profiles the data in a given table and returns a ton of useful information. The task ...

The profiling should complete successfully – indicated by a green box in SQL Server 2008 ... and looking at my (doctored) data, the Name column contains values less than 100% unique.

SQL Server 2008 Integration Services ships with the wonderful new Data Profiling Task ... The task gathers statistics for candidate keys, column length, NULL data ratio, data patterns, and ...

You can then use the trace data as input to ... up what is called a Column Filter. If you are concerned about the overhead of a Windows application like SQL Profiler, you can run a trace ...