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
Watch video Data Cleansing in SSIS - Fix Dirty Data in MS SSIS online without registration, duration hours minute second in high quality. This video was added by user WCI Data Solutions 07 May 2015, don't forget to share it with your friends and acquaintances, it has been viewed on our site 38,563 once and liked it 211 people.