Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

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

Posted on 2013-01-21
4
Medium Priority
?
410 Views
Last Modified: 2016-02-10
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.
0
Comment
Question by:rhservan
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 4

Accepted Solution

by:
krtyknmsql earned 1000 total points
ID: 38804129
0
 
LVL 5

Expert Comment

by:RehanYousaf
ID: 38805067
What type of data cleanse you looking for?
0
 

Author Comment

by:rhservan
ID: 38806309
I need to align data formatting and spelling.

E.g.

U.S.A to USA
LN. to Lane
Balk rd to Baulk Road
0
 
LVL 5

Assisted Solution

by:RehanYousaf
RehanYousaf earned 1000 total points
ID: 38807526
I think what you require is fuzzy logic in SSIS

http://oakdome.com/programming/SSIS_FuzzyLookup.php
0

Featured Post

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

My client has a dictionary table. They're defining a list of standard naming convention. Now, they are requiring my team to provide us a mechanism how to match new incoming data with existing data in their system.
A couple of weeks ago, my client requested me to implement a SSIS package that allows them to download their files from a FTP server and archives them. Microsoft SSIS is the powerful tool which allows us to proceed multiple files at same time even w…
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …

705 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question