Microsoft Research contributed the Data Profiling Task and Data Profile Viewer to Integration Services in SQL Server 2008. Best of all, this feature is available in all editions of SQL Server that include SSIS, and not just in Enterprise. Learn more about this new task from the following resources.
By their nature, SSIS package developers see the XML output from the Data Profiling task, and immediately want to process it in an SSIS package! I've marked the 3 relevant resources below with an asterisk (*). Each one demonstrates a different approach.
These are only intended to be some highlights that I was able to find easily...