Data Cleansing in SSIS - Fix Dirty Data in MS SSIS
Learn how to approach data cleansing using MS SSIS.
Using the 2012 SSIS version, watch this tutorial to discover how to cleanse your "dirty data":
Re-format manual entries to be used in a report
Look at client address and city
Correct misspelled city names and non-capitalized cities
Run a nightly job
Filtering for dirty data
Use SQL command
Use a fuzzy lookup
Join reference tables
Preview table data