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.
Who is Participating?

Improve company productivity with a Business Account.Sign Up

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


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

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.