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