Data Quality Tools, Mailing Software, Lists, NCOA, Data Enhancements
        Call 1-800-MELISSA   
Cart Shopping Cart    |    Contact Us     |                                             |     

Data Quality Direct Marketing Industries    Downloads   Support    Resources     Lookups       Company

Data Quality Components for SQL Server Integration Services (SSIS)

Easily cleanse, update and consolidate contact data within SSIS  

Now compatible with SQL Server 2012

Up to 20 percent of the data in a company’s database is incorrect or outdated according to industry experts, resulting in duplicate records, returned mail, address correction fees and lost opportunities.

Use Data Quality Components for SSIS, a suite of custom data cleansing transformation components for Microsoft SQL Server Integration Services (SSIS), to standardize, verify, correct, consolidate and update all your contact data for effective communications.

Melissa Data has leveraged the extensibility of the SSIS platform to create components that support Data Quality and master data management (MDM) including the address verification that Melissa Data is known for.

- Denise Draper, Microsoft unit manager for SSIS

Personator Contact Data Management for SSIS Video
In three simple steps, product specialist Matthew Bayne demonstrates how Personator for SSIS can cleanse, standardize and append missing information such as email addresses and phone numbers to complete your contact information, help reduce fraud, save on shipping and improve marketing campaigns.



MatchUp Component Icon
Contact Verify
  • Standardize, verify, and correct U.S. and Canadian addresses
  • Verify and normalize U.S. and Canadian phones on a 7-10 digit level
  • Parse names, genderize, and detect suspicious words or companies in name field
  • Geocode addresses by assigning rooftop lat/long coordinates*

SmartMover for SSIS Component Icon
  • Verifies name corresponds to address, email, and phone data
  • Appends missing name and company name, phone number, and/or email address

SmartMover for SSIS Component Icon
Global Verify*
  • Verifies international addresses for over 240 countries. List of supported countries
  • Transliterates many major character sets and displays output in either native or Roman characters
  • Geocodes international postal addresses by adding a latitude-longitude coordinate. List of supported countries

SmartMover for SSIS Component Icon
  • U.S./Canadian change of address processing to update addresses of people or businesses that have moved

MatchUp Component Icon
  • Identify duplicate records with domain specific knowledge of contact information
  • Perform Fuzzy Matching using over 16 different Matching Algorithms
  • Automated and Intelligent Golden Record Selection through the Data Quality Score and other Algorithms
  • List Suppression and Intersection

MatchUp Component Icon
Fuzzy Match*
  • Link related records with a toolbox of fuzzy algorithms and match thresholds
  • Outputs Matches, Possible Matches and Non-Matches based on desired threshold
  • Perform Fuzzy Matching using over 16 different Matching Algorithms
  • Regex Builder can be used to mask or clean data on the fly
  • Maintains full metadata for lineage tracking

MatchUp Component Icon
IP Locator
  • Profile Web traffic by geographical location
  • Redirect users to specific language/country pages
  • Return Lat/Long data, Zip Code™, region, and more
  • Prevent password sharing and abuse of service
  • Filter access from countries you do not do business with
* Additional subscription required

System Requirements
Data Quality Components for SSIS are 32/64 bit tools available for Windows XP/2003/2008/Vista/7 and Microsoft SQL Server 2005/2008/2012

Minimum Requirements (Not Recommended)
  • 32-Bit Windows XP/2003/2008/Vista/7
  • Microsoft SQL Server 2005/2008/2012
  • 6 GB hard-disk space

Recommended Requirements
  • 64-Bit Windows XP/2003/2008/Vista/7
  • Microsoft SQL Server 2008 R2
  • Microsoft SQL Server 2012
  • 6 GB hard-disk space

Content Verify Component
Learn how to parse, validate, correct and geocode contact information, including U.S. and Canadian addresses, phone numbers, email addresses and full names.

Fuzzy Matching Fundamentals
Got duplicate records? Learn how to use multiple fuzzy matching algorithms to link and merge related records within or across datasets with the Fuzzy Matching Component for SQL Server Integration Services (SSIS). This tutorial will show you how to easily set up the tool and view its features and functionality.

General Overview
A discussion of common issues in data quality and how these problems can be addressed using Melissa Data components for SQL Server Integration Services (SSIS).


Six Steps to Managing Data Quality with SQL Server Integration Services Global Address Data Integration to SSIS: Using Melissa Data's Global Verify Component


Contact Verify Component
Fuzzy Matching Fundamentals
General Overview

Case Studies

Cal Optima
Northern Ontario School of Medicine
SMARTech Corp.


Data Quality Components for SSIS - Brochure

Download Free Trial of Data Quality Components for SQL Server Integration (SSIS)

Demo Videos   
First Name*
Last Name*


Melissa Data Facebook Melissa Data is on Twitter  The Data Quality Authority Blog  Melissa Data LinkedIn  Melissa Data - YouTube

Data Quality
Address Solutions
Phone Solutions
Complete Contact Solutions
Email & IP Solutions
Reference Data

Direct Marketing
Mailing Software
Data Management Software
Mailing Lists
Data Hygiene Services
Data Enhancement Services
Canadian & Global Services

Data Quality Authority
Direct Marketing Authority

Customer and Events
Read Customer Stories
Press Releases
Training & Certification
Become a Partner
Find a Partner Solution

Contact Us |  Partners |  Site Map |  Privacy |  Trademarks |  Terms of use

© Copyright 2014 by Melissa DATA Corp. All trademarks are used as property of their owners.

Melissa Data
The leading international provider of data quality and address verification software. Melissa Data's affordable, easy-to-use solutions for data cleaning and deduplication can be used separately or together to provide full global data quality. Melissa Data specializes in Microsoft .NET and SQL Server Integration Services, IBM, Java and Oracle environments with APIs, Web services and enterprise plugins that empower batch and real-time applications. Melissa Data's flagship Contact Zone enables data stewards to quickly create complex data quality and data integration routines with visual programming. Melissa Data also provides a full line of direct marketing solutions including mailing software, list hygiene and data append services, and a comprehensive line of mailing lists and sales leads.