Interesting article on SSIS Data Cleansing
http://msdn.microsoft.com/sql/default.aspx?pull=/msdnmag/issues/05/09/SQLServer2005/default.aspx
For those of you who have never seen Donald Farmer from our team give his data cleansing demo, you're missing a fun show that is extremely useful. As I like to say for DWs: "Garbage in, garbage out".
Now only if I could use SSIS data cleansing to clean out my Outlook inbox :)