I am new to SSIS, What are my options for data scrubbing?

Current Environment: MS SQL Server 2008R2 AND SSIS

I have source data that I will bring in to a new table as the destination.  However,  I find there are anamolies with the data.  What are my options for performing the data cleanse within SSIS or best solutions.
rhservanAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
RehanYousafCommented:
What type of data cleanse you looking for?
0
 
rhservanAuthor Commented:
I need to align data formatting and spelling.

E.g.

U.S.A to USA
LN. to Lane
Balk rd to Baulk Road
0
 
RehanYousafConnect With a Mentor Commented:
I think what you require is fuzzy logic in SSIS

http://oakdome.com/programming/SSIS_FuzzyLookup.php
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.