rhservan
asked on
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
What type of data cleanse you looking for?
ASKER
I need to align data formatting and spelling.
E.g.
U.S.A to USA
LN. to Lane
Balk rd to Baulk Road
E.g.
U.S.A to USA
LN. to Lane
Balk rd to Baulk Road
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.