Cart Shopping Cart|Contact Us||

Data Quality Direct Mail Popular Services Industries Support Resources Lookups Company

Data Quality Components for SQL Server® Integration Services (SSIS)

Easily Cleanse, Update, and Consolidate Contact Data Within SSIS

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.

Data Quality Components for SSIS is 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.


  • Improve data quality
  • Enhance customer service
  • Streamline operational processes
  • Increase ROI & profit margins
  • Reduce Undeliverable-as-Addressed mail & shipments
  • Deliver data quality routines without writing any code or programming hassles
  • Empower business intelligence & marketing initiatives with consumer, household & lifestyle data
  • Improve data quality by correcting data before it's merged into a data warehouse


  • Compatible with Microsoft SQL Server 2008/2012/2014
  • Verify U.S. and international addresses for over 240 countries & territories
  • Add rooftop lat/long coordinates to addresses
  • Easy to use and intuitive interface with drag/drop capabilities
  • Broad connectivity to any type of data
  • De-duplicate and cleanse inconsistent and redundant data
  • Validate, standardize, and correct name, address, e-mail, and telephone data
  • Get accurate demographic info on individuals and household
  • Analyze quality of data in columns
  • Free unlimited technical support. Learn more.
  • 120-Day ROI Guarantee. Details here.
Data Quality Components For SQL Server Integration Services (SSIS) Components

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 for better data warehousing, analytics, and bottom-line results.

“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

Customize your suite by adding the components of your choice. Each component requires a subscription and is sold separately:

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 U.S. addresses by assigning rooftop lat/long coordinates*


  • Verifies name corresponds to address, email, and phone data
  • Appends missing name and company name, phone number, and/or email address
  • Adds valuable demographic information like occupation, presence of children, marital status, and much more
  • Includes data for both the U.S. & Canada


  • Supports building a target schema dynamically with sizes, nulls, unique counts, length, and field identification
  • Brings data quality analysis to data contained in columns
  • Uses every available general profiling count on the market today
  • Allows regexes and error thresholds to be set for full-fledged monitoring
  • Uses sophisticated matching to output fuzzy and exact match counts
  • Available as a commercial C++ Data Profiler API that can be OEM’d into custom apps

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
  • Parses and genderizes full names and standardizes company names
  • Verifies international phone numbers and appends geographic info
  • Parses, validates, and standardizes international email addresses (includes Real-time Email Mailbox Verification)


  • U.S./Canadian change-of-address processing to update addresses of people and businesses that have moved


  • 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

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
  • Algorithms employed include Exact, Jaro-Winkler, levenshtein, Dice's Coefficient, Frequency Near, and many more
  • Regex Builder can be used to mask or clean data on-the-fly
  • Maintains full metadata for lineage tracking

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


  • Comprehensive U.S. property and mortgage data (over 140 million records)
  • 12 main categories and 165 information fields available
  • Weekly updates
  • Options include Basic or Detailed output
Download Free Trial of Data Quality Components for SQL Server Integration (SSIS) Live Demo
Address Coverage
by Country

Download Free Trial of Data Quality Components for SSIS Community Edition

Melissa Data Corporation BBB Business Review

Melissa Data SOC 2 Type 1

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

Data Quality
Cloud Services
Reference Data

Direct Mail
Mailing Lists
Mailing Products
Cloud Services
Popular Services
Data Enhancements
Data Hygiene

Data Quality Authority
Direct Marketing Authority

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

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

© Copyright 2015 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 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.