Data Profiling in SSIS
May 8, 2007[From Jumpstart TV]
In this presentation, Ira shows you how to data profile in SSIS using a Script transform and some creative methods like RegEx. He shows you how to look for patterns in your data to find bad data that wouldn't be obvious to the eye or casual viewer.
The article continues at http://www.jumpstarttv.com/Media.aspx?vid=72