Build History:SSIS:Data Quality Components

← SSIS:Data Quality Components

Build 8.2

Released May 2018

Compatibility Summary

2005 SSIS Components are no longer being updated and supported. These components will now remain static. This release officially supports SQL Server 2016 and SQL Server 2017. Global Phone V3 was be depreciated in Q4. We have replaced it with a new Global Phone V4 WS which offers real-time phone check.

Contact Verification Component

Version: 1.0.1.5017

Address Object Build: 3067

Name Object Build: 3067

Phone Object Build: 3067

Email Object Build: 3067

Geocoder Object Build: 3108

MatchUp Object Build: 5023

Database Date: 04/15/2018

Changes

• None

Personator Component

Version: 1.0.0.5022

Changes

• None

Smartmover Component

Version: 1.2.0.5018

Changes

• The following output field has been added

• Delivery Indication - Returns RBDI (Residential Business Delivery Indicator) information for addresses. Most shipping carriers charge a higher price for residential deliveries. RBDI helps ensure that you select the most cost-effective function for shipping parcels by identifying residential addresses. The field will output R for residential address, B for business address or U for unknown.

Fuzzy Matching Component

Version 2.0.0.5011

Changes

• None

Matchup Component

Version 2.2.0.5022

Changes

• None

Global Verify Component

Version 2.1.0.5022

Global Address Object Build: 2997 (32bit), 2962 (64bit)

Database Date: 04/15/2018

Changes

• None

IP Locator Component

Version 1.0.0.5013

Changes

• None

Property Component

Version 1.0.0.5035

Changes

• Fixed Bugs:

• Basic output fields selected by default
• Account input field has been moved under FIPS field in interface
• Basic output fields can now be selected individually

• The following output fields have been added

• Shape - Well Known Text - Returns parcel shape information

Profiler Component

Version 1.0.0.5016

Changes

• None

Businesscoder Component

Version 1.0.0.5021

Changes

• None

Generalized Cleanser Component

Version 1.0.0.5015

Changes

• None

Personator World Component

Version 1.0.0.5020

Changes

• None

Build 8.1

Released February 2018

Compatibility Summary

2005 SSIS Components are no longer being updated and supported. These components will now remain static. This release officially supports SQL Server 2016. Global Phone V3 was be depreciated in Q4. We have replaced it with a new Global Phone V4 WS which offers real-time phone check.

Contact Verification Component

Version: 1.0.1.5011

Address Object Build: 3067

Name Object Build: 3067

Phone Object Build: 3067

Email Object Build: 3067

Geocoder Object Build: 3108

MatchUp Object Build: 5023

Database Date: 01/15/2018

Changes

• New Feature:

• Added Local Geologging - A log file containing the Customer ID, Date/Time, GS01-GS06 result code counts and a Checksum for unique records.

Personator Component

Version: 1.0.0.5014

Changes

• New Feature:

• Move Confidence Removal
• Added Social Security Number (SSN) Input
• Added Social Security Number (SSN) Result Codes

VR11 - Name and SSN Match - Matched the name field to the Social Security Number.

VS50 - Last4 Only Match - The name only matched to the last 4 digits of the Social Security Number.

SN01 - Invalid SSN Format - The format of your Social Security Number was invalid.

• Added Social Security to Centric Hint in Processing Options
• Added Social Security Number Cascade Option

When the option is turned on, this will allow SSN validation to cascade down the set of rules described below until a match is found

Full Name + Full SSN: VR11 if match, SP01 if no match

Last Name + Full SSN: VR11,VS12 if match, SP01 if no match

Full Name + Last 4 SSN: VR11,VS50 if match, SP01 if no match

Last Name + Last 4 SSN: VR11,VS12,VS50 if match, SP01 if no match

• Added the following output fields to the Personator Demographics Output Group

ChildrenAgeRange - Returns the age range of children present in the household.

CreditCardUser - Returns whether the user has a credit card or not.

Education - Returns the highest level of education completed by an individual.

EthnicCode - Returns an individual’s specific ethnicity.

EthnicGroup - Returns the grouped category for a person’s ethnicity. This is a more generalized grouping compared to Ethnic Codes.

HouseholdSize - Returns the number of occupants in the household.

PoliticalParty - Returns an individual’s political affiliation.

PresenceOfSenior - Returns the presence of senior(s) in the household.

• Added the following output fields to the Personator Output Columns

MelissaAddressKey - Returns a unique key associated with an address.

MelissaAddressKeyBase - Returns a unique key associated with a building containing multiple suites/apartments.

PhoneCountryName - Returns the full country name for the phone number entered in the Phone field.

PhoneCountryCode - Returns the 2 character country code for the phone number entered in the Phone field.

Smartmover Component

Version: 1.2.0.5010

Changes

• Added MoveTypeCode to output column

• MoveTypeCode - Type of move (individual or business)

Fuzzy Matching Component

Version 2.0.0.5008

Changes

• None

Matchup Component

Version 2.2.0.5015

Changes

• Fixed Bugs:

• Mappings reset when global matchcode components changed

Global Verify Component

Version 2.1.0.5018

Global Address Object Build: 2921 (32bit), 2921 (64bit)

Database Date: 10/15/2018

Changes

• New Feature:

• Added output field

Country Subdivision Code - This is the ISO3166-2 code for country subdivisions, usually tied to the administrative area for a country. The format is the 2 letter country code followed by a dash followed by 2 or 3 characters or two numbers.

IP Locator Component

Version 1.0.0.5009

Changes

• None

Property Component

Version 1.0.0.5027

Changes

• New Feature:

• Added V4 LookupProperty Output Fields

GrpParcel

FIPSCode

County

UnformattedAPN

FormattedAPN

AlternateAPN

APNYearChange

PreviousAPN

AccountNumber

YearAdded

MapBook

MapPage

TaxJurisdiction

CBSAName

CBSACode

MSAName

MSACode

MetropolitanDivision

MinorCivilDivisionName

MinorCivilDivisionCode

NeighborhoodCode

CensusTract

CensusBlockGrp

CensusBlock

GrpLegal

LegalDescription

Range

Township

Section

Quarter

QuarterQuarter

Subdivision

Phase

TractNumber

Block1

Block2

LotNumber1

LotNumber2

LotNumber3

Unit

GrpPropertyAddress

Address

City

State

Zip

CarrierRoute

AddressKey

MAK

BaseMAK

Latitude

Longitude

PrivacyInfo

GrpParsedPropertyAddress

Range

PreDirectional

StreetName

Suffix

PostDirectional

SuiteName

SuiteRange

GrpPrimaryOwner

Name1Full

Name1First

Name1Middle

Name1Last

Name1Suffix

TrustFlag

CompanyFlag

Name2Full

Name2First

Name2Middle

Name2Last

Name2Suffix

Type

VestingType

GrpSecondaryOwner

Name3Full

Name3First

Name3Middle

Name3Last

Name3Suffix

Name4Full

Name4First

Name4Middle

Name4Last

Name4Suffix

Type

GrpOwnerAddress

Address

City

State

Zip

CarrierRoute

MAK

BaseMAK

FormatInfo

PrivacyInfo

OwnerOccupied

GrpLastDeedOwnerInfo

Name1Full

Name1First

Name1Middle

Name1Last

Name1Suffix

Name2Full

Name2First

Name2Middle

Name2Last

Name2Suffix

Name3Full

Name3First

Name3Middle

Name3Last

Name3Suffix

Name4Full

Name4First

Name4Middle

Name4Last

Name4Suffix

GrpCurrentDeed

MortgageAmount

MortgageDate

MortgageLoanTypeCode

MortgageTermCode

MortgageTerm

MortgageDueDate

LenderCode

LenderName

SecondMortgageAmount

SecondMortgageLoanTypeCode

GrantorName1Full

GrantorName2Full

GrantorName3Full

GrantorName4Full

GranteeName1Full

GranteeName2Full

GranteeName3Full

GranteeName4Full

GrpTax

YearAssessed

AssessedValueTotal

AssessedValueImprovements

AssessedValueLand

AssessedImprovementsPerc

PreviousAssessedValue

MarketValueYear

MarketValueTotal

MarketValueImprovements

MarketValueLand

MarketImprovementsPerc

TaxFiscalYear

TaxRateArea

TaxBilledAmount

TaxDelinquentYear

LastTaxRollUpdate

AssrLastUpdated

TaxExemptionHomeowner

TaxExemptionDisabled

TaxExemptionSenior

TaxExemptionVeteran

TaxExemptionWidow

TaxExemptionAdditional

GrpPropertyUseInfo

YearBuilt

YearBuiltEffective

ZonedCodeLocal

PropertyUseMuni

PropertyUseGroup

PropertyUseStandardized

GrpSaleInfo

AssessorLastSaleDate

AssessorLastSaleAmount

AssessorPriorSaleDate

AssessorPriorSaleAmount

LastOwnershipTransferDate

LastOwnershipTransferDocumentNumber

LastOwnershipTransferTxID

DeedLastSaleDocumentBook

DeedLastSaleDocumentPage

DeedLastDocumentNumber

DeedLastSaleDate

DeedLastSalePrice

DeedLastSaleTxID

GrpPropertySize

AreaBuilding

AreaBuildingDefinitionCode

AreaGross

Area1stFloor

Area2ndFloor

AreaUpperFloors

AreaLotAcres

AreaLotSF

LotDepth

LotWidth

AtticArea

AtticFlag

BasementArea

BasementAreaFinished

BasementAreaUnfinished

ParkingGarage

ParkingGarageArea

ParkingCarport

ParkingCarportArea

GrpPool

Pool

PoolArea

SaunaFlag

GrpIntStructInfo

Foundation

Construction

InteriorStructure

PlumbingFixturesCount

ConstructionFireResistanceClass

SafetyFireSprinklersFlag

FlooringMaterialPrimary

GrpIntRoomInfo

BathCount

BathPartialCount

BedroomsCount

RoomsCount

StoriesCount

UnitsCount

BonusRoomFlag

BreakfastNookFlag

CellarFlag

CellarWineFlag

ExcerciseFlag

FamilyCode

GameFlag

GreatFlag

HobbyFlag

LaundryFlag

MediaFlag

MudFlag

OfficeArea

OfficeFlag

SafeRoomFlag

SittingFlag

StormFlag

StudyFlag

SunroomFlag

UtilityArea

UtilityCode

GrpIntAmenities

Fireplace

FireplaceCount

AccessabilityElevatorFlag

AccessabilityHandicapFlag

EscalatorFlag

CentralVacuumFlag

IntercomFlag

SoundSystemFlag

WetBarFlag

SecurityAlarmFlag

GrpExtStructInfo

StructureStyle

Exterior1Code

RoofMaterial

RoofConstruction

StormShutterFlag

OverheadDoorFlag

GrpExtAmenities

ViewDescription

PorchCode

PorchArea

PatioArea

DeckFlag

DeckArea

FeatureBalconyFlag

BalconyArea

BreezewayFlag

GrpExtBuildings

BuildingsCount

BathHouseArea

BathHouseFlag

BoatAccessFlag

BoatHouseArea

BoatHouseFlag

CabinArea

CabinFlag

CanopyArea

CanopyFlag

GazeboArea

GazeboFlag

GranaryArea

GranaryFlag

GreenHouseArea

GreenHouseFlag

GuestHouseArea

GuestHouseFlag

KennelArea

KennelFlag

LeanToArea

LeanToFlag

LoadingPlatformArea

LoadingPlatformFlag

MilkHouseArea

MilkHouseFlag

OutdoorKitchenFireplaceFlag

PoolHouseArea

PoolHouseFlag

PoultryHouseArea

PoultryHouseFlag

QuonsetArea

QuonsetFlag

ShedArea

ShedCode

SiloArea

SiloFlag

StableArea

StableFlag

StorageBuildingArea

StorageBuildingFlag

UtilityBuildingArea

UtilityBuildingFlag

PoleStructureArea

PoleStructureFlag

GrpUtilities

HVACCoolingDetail

HVACHeatingDetail

HVACHeatingFuel

SewageUsage

WaterSource

MobileHomeHookupFlag

GrpParking

RVParkingFlag

ParkingSpaceCount

DrivewayArea

DrivewayMaterial

GrpYardGardenInfo

TopographyCode

FenceCode

FenceArea

CourtyardFlag

CourtyardArea

ArborPergolaFlag

SprinklersFlag

GolfCourseGreenFlag

TennisCourtFlag

SportsCourtFlag

ArenaFlag

WaterFeatureFlag

PondFlag

BoatLiftFlag

GrpEstimatedValue

EstimatedValue

EstimatedMinValue

EstimatedMaxValue

ConfidenceScore

ValuationDate

Profiler Component

Version 1.0.0.5009

Changes

• None

Businesscoder Component

Version 1.0.0.5013

Changes

• None

Generalized Cleanser Component

Version 1.0.0.5008

Changes

• Fixed Bugs:

• Invalid Expression error now fixed

Personator World Component

Version 1.0.0.5014

Changes

• None

Build 7.4

Released November 2017

Compatibility Summary

2005 SSIS Components are no longer being updated and supported. These components will now remain static. This release officially supports SQL Server 2016. Global Phone V3 was be depreciated in Q4. We have replaced it with a new Global Phone V4 WS which offers real-time phone check.

Contact Verification Component

Version: 1.0.1.5006

Address Object Build: 2961

Name Object Build: 2961

Phone Object Build: 2961

Email Object Build: 2961

Geocoder Object Build: 2961

MatchUp Object Build: 5015

Database Date: 10/15/2017

Changes

• Fixed Bugs:

• Name in CompanyName Field doesn't save output settings

Personator Component

Version: 1.0.0.5008

Changes

• Fixed Bugs:

• Move Confidence Removal

Smartmover Component

Version: 1.2.0.5005

Changes

• None

Fuzzy Matching Component

Version 2.0.0.5004

Changes

• None

Matchup Component

Version 2.2.0.5009

Changes

• Fixed Bugs:

• MatchCode Editor Label Character Limit
• Mappings reset when global matchcode components changed

Global Verify Component

Version 2.1.0.5010

Global Address Object Build: 2921 (32bit), 2921 (64bit)

Database Date: 10/15/2017

Changes

• Fixed Bugs:

• On Premise Unhandled Exception
• Global Phone reporting incorrect statistics
• Global Address ignoring configuration file for Batch Size and Thread Count

IP Locator Component

Version 1.0.0.5005

Changes

• None

Property Component

Version 1.0.0.5005

Changes

• None

Profiler Component

Version 1.0.0.5006

Changes

• Fixed Bugs:

• Word Value Frequencies output is not returned

Businesscoder Component

Version 1.0.0.5009

Changes

• None

Generalized Cleanser Component

Version 1.0.0.5005

Changes

• Fixed Bugs:

• Configuration prevents changing of licenses

Personator World Component

Version 1.0.0.5008

Build 7.3

Released August 2017

Compatibility Summary

2005 SSIS Components are no longer being updated and supported. These components will now remain static. This release officially supports SQL Server 2016. Global Phone V3 was be depreciated in Q4. We have replaced it with a new Global Phone V4 WS which offers real-time phone check.

Contact Verification Component

Version: 1.0.1.5003

Address Object Build: 2961

Name Object Build: 2961

Phone Object Build: 2961

Email Object Build: 2961

Geocoder Object Build: 2961

MatchUp Object Build: 3224

Database Date: 04/15/2017

Changes

• None

Personator Component

Version: 1.0.0.5005

Changes

• New Output Field:
• MoveDate - Returns the date associated with move address

Smartmover Component

Version: 1.2.0.5003

Changes

• New Output Fields:
• BaseMelissaAddressKey - Returns a unique key associated with a building containing multiple suites/apartments
• MelissaAddressKey - Returns a unique key associated with an address
• StandardizedBaseMelissaAddressKey
• StandardizedMelissaAddressKeyComponent

Fuzzy Matching Component

Version 2.0.0.5003

Changes

• None

Matchup Component

Version 2.2.0.5003

Changes

• None

Global Verify Component

Version 2.1.0.5004

Global Address Object Build: 2921 (32bit), 2921 (64bit)

Database Date: 7/15/2017

Changes

• Fixed Issue with On Premise license decryption

IP Locator Component

Version 1.0.0.5003

Changes

• New response fields: ProxyType and ProxyDescription
• New result code: IS03 – The IP address is a proxy

Property Component

Version 1.0.0.5003

Changes

• None

Profiler Component

Version 1.0.0.6689

Changes

• None

Businesscoder Component

Version 1.0.0.5007

Changes

New Output Filter

• Contacts Output - Returns JSON Array: NameFirst, NameLast, Gender, Title, and Email of one or more contacts.
• This will output to a separate filter with a primary key of your choosing. We recommend using a RecordID as the primary key, to link every contact returned to that unique ID.

New Output Fields

• TotalContacts - Returns the number of employee contacts we have in our databases
• EIN - The Employer Identification Number for the business

Generalized Cleanser Component

Version 1.0.0.5003

Changes

• Regex builder crash

Build 7.2

Released May 2017

Compatibility Summary

2005 SSIS Components are no longer being updated and supported. These components will now remain static. This release officially supports SQL Server 2016. Global Phone V3 was be depreciated in Q4. We have replaced it with a new Global Phone V4 WS which offers real-time phone check.

Contact Verification Component

Version: 1.0.1.2929

Address Object Build: 2961

Name Object Build: 2961

Phone Object Build: 2961

Email Object Build: 2961

Geocoder Object Build: 2961

MatchUp Object Build: 3224

Database Date: 04/15/2017

Changes

• None

Personator Component

Version: 1.0.0.2929

Changes

• None

Smartmover Component

Version: 1.2.0.2929

Changes

• Fixed Bugs:

• Component Crashes when you define Input Address for Country and try to click the box "Use Input Fields for Output" under Output columns

Fuzzy Matching Component

Version 2.0.0.2929

Changes

• None

Matchup Component

Version 2.2.0.2929

Changes

• Fixed Bugs:

• Under Advanced Survivorship, all the expressions in Column and variables under Custom Expression can't be seen when opening the Advanced survivorship after the first time.
• MatchUp editor closes after trying to create new matchcode
• Create Matchcode dialog box broken
• Misleading error message for license issue
• Crash occurs when selecting a matchcode with no rules
• Survivorship/Pass-Through does not save columns selected
• Component closes out when double clicking on Options bar
• Crashing if used in SQL Agent
• Crash after selecting Match Code and filling in Field Mappings under Survivorship/Pass-Through Column when clicking the "Select All" box
• Crash when create new match code with no data type

Global Verify Component

Version 2.1.0.2929

Global Address Object Build: 2921 (32bit), 2921 (64bit)

Database Date: 4/15/2017

Changes

• None

IP Locator Component

Version 1.0.0.2929

Changes

• None

Property Component

Version 1.0.0.2929

Changes

• None

Profiler Component

Version 1.0.0.2929

Changes

• None

Businesscoder Component

Version 1.0.0.2929

Changes

• None

Generalized Cleanser Component

Version 1.0.0.4474

Changes

• Fixed Bugs:

• Expression Syntax Error on Expression that Passes Check inside Expression Builder

Build 7.1

Released February 2017

Compatibility Summary

2005 SSIS Components are no longer being updated and supported. These components will now remain static. This release officially supports SQL Server 2016. Global Phone V3 was be deprecated in Q4. We have replaced it with a new Global Phone V4 WS which offers real-time phone check.

Contact Verification Component

Version: 1.0.1.2928

Address Object Build: 2896

Name Object Build: 2896

Phone Object Build: 2896

Email Object Build: 2896

Geocoder Object Build: 2872

MatchUp Object Build: 2768

Database Date: 2/15/2017

Changes

• Email - Time To Wait Option has been added
• TimeToWait allows you to select how long (in seconds) that you would like our web service to wait on a single email before it times out. Select a smaller number if time is of essence, or longer if you would prefer more accurate results.
• DaysSinceLastVerified -This option is deprecated.

Option Name	Parameter	Description
TimeToWait	#[5-45]	Default set to 25. Select how long the web service will wait before it times out on an email.

Personator Component

Version: 1.0.0.2928

Changes

• Fixed mistype in window

SmartMover Component

Version: 1.2.0.2928

Changes

• None

Fuzzy Matching Component

Version 2.0.0.2928

Changes

• None

MatchUp Component

Version 2.2.0.2928

Changes

• None

Global Verify Component

Version 2.1.0.2928

Global Address Object Build: 2771 (32bit), 2771 (64bit)

Database Date: 2/15/2017

Changes

• Gloabl Phone:

Global Phone now outputs Caller ID

• Global Email:

Deprecated DaysSinceLastVerified option for Global Email

Email - TimeToWait Option has been added

TimeToWait allows you to select how long (in seconds) that you would like our web service to wait on a single email before it times out. Select a smaller number if time is of essence, or longer if you would prefer more accurate results.

Option Name	Parameter	Description
TimeToWait	#[5-45]	Default set to 25. Select how long the web service will wait before it times out on an email.

IP Locator Component

Version 1.0.0.2928

Changes

• None

Property Component

Version 1.0.0.2928

Changes

• None

Profiler Component

Version 1.0.0.2928

Changes

• None

Business Coder Component

Version 1.0.0.2928

Changes

• None

Generalized Cleanser Component

Version 1.0.0.2928

Changes

• New Component

Build 6.4

Released November 2016

Compatibility Summary

2005 SSIS Components are no longer being updated and supported. These components will now remain static. IPLocator Local will be deprecated in Q3. We will be replacing it with a new IPLocator WS.

Contact Verification Component

Version: 1.0.1.2880

Address Object Build: 2819

Name Object Build: 2819

Phone Object Build: 2819

Email Object Build: 2819

Geocoder Object Build: 2872

MatchUp Object Build: 2872

Database Date: 10/15/2016

Changes

• None

Personator Component

Version: 1.0.0.2880

Changes

• None

SmartMover Component

Version: 1.2.0.2880

Changes

• None

Fuzzy Matching Component

Version 2.0.0.2880

Changes

• None

MatchUp Component

Version 2.2.0.2880

Changes

• None

Global Verify Component

Version 2.1.0.2880

Global Address Object Build: 2771 (32bit), 2771 (64bit)

Database Date: 10/15/2016

Changes

• Global Phone:

V4 is now released: https://globalphone.melissadata.net/v4/WEB/GlobalPhone

• + can now be inputted into DefaultCallingCode
• PS20/PS21/PS22 result codes no longer show when there is a PE03 result code
• Parentheses for + codes now parsed correctly, e.g (+1)4084161450
• InternationalPhoneNumber is a combination of the country dialing code + phone number, added as a new field called InternationalPhoneNumber
• Phone input range increased to 20 digits (meaning you can input up to 20 digits without returning a PE error; previously 16)
• Latitude and Longitudes for numbers that are not geographically tied to an area (toll free numbers) are now empty strings instead of 0,0

• Global Email:

Removed:

DaysSinceLastVerified (Deprecated)

• New Advanced Logic deprecates this option.

Bug Fix:

• Fixed a bug related to Domain Correction

General Improvements:

• Improved Cache Queries
• Improved Validation Speeds
• Increased Thread Stability

IPLocator Component

Version 1.0.0.2880

Changes

• IP Locator V2 Web Service and On Premise capabilities are now deprecated
• IP Locator V4 is now released

• More comprehensive set of global IP4 Addresses (covers 99.999 % of the internet)
• Leverages a “living network” from mobile devices and billions of real-time data points
• Additional appends such as ‘Connection Speed’ and ‘Connection Type’
• Updated Weekly
• In order to ensure no loss of data, all current data points in the legacy IP Locator V2 Web Service are also available in the IP Locator V4 Web Service

Property Component

Version 1.0.0.2880

Changes

• None

Profiler Component

Version 1.0.0.2880

Changes

• Bug Fixed - License Key is not updating when entered in advanced configuration

Business Coder Component

Version 1.0.0.2880

Changes

• Bug Fixed - License Key is not updating when entered in advanced configuration

Build 6.3

Released August 2016

Compatibility Summary

2005 SSIS Components are no longer being updated and supported. These components will now remain static. IPLocator Local will be deprecated in Q3. We will be replacing it with a new IPLocator WS.

Contact Verification Component

Version: 1.0.1.2826

Address Object Build: 2819

Name Object Build: 2819

Phone Object Build: 2819

Email Object Build: 2819

Geocoder Object Build: 2674

MatchUp Object Build: 2768

Database Date: 7/15/2016

Changes

• None

Personator Component

Version: 1.0.0.2826

Changes

• None

SmartMover Component

Version: 1.2.0.2826

Changes

• None

Fuzzy Matching Component

Version: 2.0.0.2826

Changes

• None

MatchUp Component

Version: 2.2.0.2826

Changes

• None

Global Verify Component

Version: 2.1.0.2826

Global Address Object Build: 2771 (32bit), 2771 (64bit)

Database Date: 07/15/2016

Changes

• Global Email: Date Checked field has been added

IPLocator Component

Version: 1.0.0.2826

Changes

• IP Locator V2 Web Service and On Premise capabilities are now deprecated
• IP Locator V4 is now released

• More comprehensive set of global IP4 Addresses (covers 99.999 % of the internet)
• Leverages a “living network” from mobile devices and billions of real-time data points
• Additional appends such as ‘Connection Speed’ and ‘Connection Type’
• Updated Weekly
• In order to ensure no loss of data, all current data points in the legacy IP Locator V2 Web Service are also available in the IP Locator V4 Web Service

Property Component

Version: 1.0.0.2826

Changes

• None

Profiler Component

Version: 1.0.0.2826

Changes

• None

Business Coder Component

Version: 1.0.0.2826

Changes

• New Component

Build 6.2

Released May 2016

Contact Verification Component

Version: 1.0.1.2777

Address Object Build: 2777

Name Object Build: 2777

Phone Object Build: 2777

Email Object Build: 2777

Geocoder Object Build: 2674

MatchUp Object Build: 2768

IpLocator Object Build: 2615

Database Date: 4/15/2015

Changes

• None
• Various bug fixes.

Personator Component

Version: 1.0.0.2777

Changes

• GrpCensus2 columns have been added

Column Name	Column Description
CensusKey	Contains the concatenated County FIPS, Census Tract and Census Block
CountySubDivisionCode	Contains the County Subdivision code
CountySubDivisionName	Contains the County Subdivision name
ElementarySchoolDistrictCode	Contains the Elementary School District Code
ElementarySchoolDistrictName	Contains the Elementary School District Name
SecondarySchoolDistrictCode	Contains the Secondary School District Code
SecondarySchoolDistrictName	Contains the Secondary School District Name
UnifiedSchoolDistrictCode	Contains the Unified School District Code
UnifiedSchoolDistrictName	Contains the Unified School District Name
StateDistrictUpper	Contains the Upper State District Code
StateDistrictLower	Contains the Lower State District Code

SmartMover Component

Version: 1.0.1.2777

Changes

• None

Fuzzy Matching Component

Version 2.0.0.2777

Changes

• None

MatchUp Component

Version 2.2.0.2777

Changes

• Various bug fixes.

Global Verify Component

Version 2.0.0.2730

Global Address Object Build: 2620 (32bit), 2600 (64bit)

Changes

• None

IP Locator Component

Version 1.0.0.2730

Changes

• None

Property Component

Version 1.0.0.2730

Changes

• None

Profiler Component

Version 1.0.0.2730

Changes

• None

BusinessCoder Component

Version 1.0.0.2730

Changes

• New Component

Build 6.1

Released February 2016

Contact Verification Component

Version: 1.0.1.2730

Address Object Build: 2710

Name Object Build: 2710

Phone Object Build: 2710

Email Object Build: 2710

Geocoder Object Build: 2674

MatchUp Object Build: 2721

IpLocator Object Build: 2615

Database Date: 1/15/2015

Changes

• Email component now has a 'Perform WS Lookup' option for On-Premise processing. With this option enabled, the user can send their emails to the global email webservice for real time validation.
• Express and Premium modes are now enabled for webservice processing or WS lookup.
• Various bug fixes.

Personator Component

Version: 1.0.0.2730

Changes

• Move Default Set to Strict

SmartMover Component

Version: 1.0.1.2730

Changes

• None

Fuzzy Matching Component

Version 2.0.0.2730

Changes

• None

MatchUp Component

Version 2.2.0.2730

Changes

• Various bug fixes.

Global Verify Component

Version 2.0.0.2730

Global Address Object Build: 2620 (32bit), 2600 (64bit)

Changes

• None

IP Locator Component

Version 1.0.0.2730

Changes

• None

Property Component

Version 1.0.0.2730

Changes

• None

Profiler Component

Version 1.0.0.2730

Changes

• None

Build 5.4

Released November 2015

Patch Released January 2016 [Build 2683]

Contact Verification Component

Version: 1.0.1.2683

Address Object Build: 2575

Name Object Build: 2613

Phone Object Build: 2613

Email Object Build: 2554

Geocoder Object Build: 2670

MatchUp Object Build: 2628

IpLocator Object Build: 2615

Database Date: 10/15/2015

Changes

• Community edition now requires a community edition License Key, rather than no License Key

Personator Component

Version: 1.0.0.2683

Changes

• Fixed an issue with transaction size

SmartMover Component

Version: 1.0.1.2683

Changes

• Transaction size setting locked to 100 records in accordance to USPS regulations

Fuzzy Matching Component

Version 2.0.0.2683

Changes

• None

MatchUp Component

Version 2.2.0.2683

Changes

• International Matchup capabilities now added to Matchup Component
• Community edition now requires a community edition License Key, rather than no License Key
• Fixed an issue where users would experience field mapping issues in a matchcode (address 4-8)
• Fixed database expiration issue

Global Verify Component

Version 2.0.0.2683

Global Address Object Build: 2620 (32bit), 2600 (64bit)

Changes

• Added new On-Premise component
• New processing modes: Webservice, On-Premise, Hybrid. WS sends all records to webservice, on-premise sends all records to the local object, and hybrid sends specified records to webservice OR the local object.

IP Locator Component

Version 1.0.0.2683

Changes

• None

Property Component

Version 1.0.0.2683

Changes

• None

Profiler Component

Version 1.0.0.2683

Changes

• Community edition now requires a community edition License Key, rather than no License Key

Build 5.3

Released August 2015

Contact Verification Component

Version: 1.0.1.2626

Address Object Build: 2613

Name Object Build: 2613

Phone Object Build: 2613

Email Object Build: 2554

Geocoder Object Build: 2615

MatchUp Object Build: 2564

IpLocator Object Build: 2554

Database Date: 7/15/2015

Changes

• Added more result codes to the output result filter

Personator Component

Version: 1.0.0.2626

Changes

• Fixed a problem where the "Verify" action was not being sent
• Fixed a problem where the Personator window would crash under certain circumstances
• Added more result codes to the output result filter

SmartMover Component

Version: 1.0.1.2626

Changes

• Files with less than 100 records will not be processed as per USPS regulations

Fuzzy Matching Component

Version 2.0.0.2626

Changes

• Fixed spelling error in output tab

MatchUp Component

Version 2.2.0.2626

Changes

• Fixed an issue where matchcodes could not use (UK) data types
• Fixed an issue where DT_Numeric data types could not have a precision value greater than scale value
• Fixed an issue where the advanced survivorship would crash the component in certain circumstances
• Fixed several spelling mistakes

Global Verify Component

Version 2.0.0.2626

Global Address Object Build: 2620 (32bit), 2600 (64bit)

Changes

• Added new On-Premise component
• With a proper License Key, users can now verify global data on their machine rather than web service
• Fixed various issues with On-Premise mode

IP Locator Component

Version 1.0.0.2626

Changes

• None

Property Component

Version 1.0.0.2626

Changes

• None

Profiler Component

Version 1.0.0.2626

Changes

• None

Build 5.2

Released May 2015

Contact Verification Component

Version: 1.0.1.2575

Address Object Build: 2554

Name Object Build: 2554

Phone Object Build: 2554

Email Object Build: 2554

Geocoder Object Build: 2554

MatchUp Object Build: 2554

IpLocator Object Build: 2554

Database Date: 4/15/2015

Changes

• fixed "Decimal" option unselectable in "Default Lat/Long Column Type"

Personator Component

Version: 1.0.0.2575

Changes

• Personator restriction fixes and GUI changes.
• Move confidence option now has "Loose" and "Strict" options.

SmartMover Component

Version: 1.0.1.2575

Changes

• None

Fuzzy Matching Component

Version 2.0.0.2575

Changes

• None

MatchUp Component

Version 2.2.0.2575

Changes

• fixed MatchCode Editor swap crash

Global Verify Component

Version 2.0.0.2575

Changes

• Fixed a few German translations and spelling
• German localization for GV.
• Global Email interface changes.
• Output filter ES23 description update

IP Locator Component

Version 1.0.0.2575

Changes

• None

Property Component

Version 1.0.0.2575

Changes

• None

Profiler Component

Version 1.0.0.2575

Changes

• Added InferredColumnType column.
• Fixed issue where users would get error if they didn’t specify any output fields on the passthrough/results pin.

Build 5.1

Released February 2015

Contact Verification Component

Version: 1.0.1.2503

Address Object Build: 2502

Name Object Build: 2502

Phone Object Build: 2502

Email Object Build: 2502

Geocoder Object Build: 2502

MatchUp Object Build: 2408

IpLocator Object Build: 2502

Database Date: 1/15/2015

Changes

• Fixed behavior of ‘Output Filter’ tab’s Filter controls in some instances.

Personator Component

Version: 1.0.0.2499

Changes

• Added Demographics fields.

SmartMover Component

Version: 1.0.1.2503

Changes

• None

Fuzzy Matching Component

Version 2.0.0.2502

Changes

• None

MatchUp Component

Version 2.2.0.2499

Changes

• Fixed issue where slow machines would crash if user changed tabs quickly during GUI startup.

Global Verify Component

Version 2.0.0.2503

Changes

• Dialog not saving changes in rare instances.
• User is now allowed to pass Advanced Configuration test with only some activated web services.
• ‘Default Lat/Long Column Type’ would not display checkmark if the selection was ‘Decimal’

IP Locator Component

Version 1.0.0.2503

Changes

• None

Property Component

Version 1.0.0.2499

Changes

• None

Profiler Component

Version 1.0.0.2503

Changes

• Fixed issue where users would get error if they didn’t specify any output fields on the passthrough/results pin.

Build 4.4

Released November 2014

Contact Verification Component

Version: 1.0.1.2449

Address Object Build: 2431

Name Object Build: 2431

Phone Object Build: 2431

Email Object Build: 2431

Geocoder Object Build: 2441

MatchUp Object Build: 2441

IpLocator Object Build: 2441

Database Date: 10/15/2014

Changes

• None

Personator Component

Version: 1.0.0.2449

Changes

• Fixed a problem where output filters were not being saved
• Improved performance when saving the component

SmartMover Component

Version: 1.0.1.2449

Changes

• Fixed a backwards compatibility issue
• Fixed a problem where output filters were not being saved

Fuzzy Matching Component

Version 2.0.0.2449

Changes

• None

MatchUp Component

Version 2.2.0.2449

Changes

• None

Global Verify Component

Version 2.0.0.2449

Changes

• Added new Name Tab and Functionalities
• Added new Phone Tab and Functionalities
• Added new Email Tab and Functionalities

IP Locator Component

Version 1.0.0.2449

Changes

• None

Property Component

Version 1.0.0.2449

Changes

• New Component

Build 4.3

Released August 2014

Contact Verification Component

Version: 1.0.1. 2419

Address Object Build: 2381

Name Object Build: 2381

Phone Object Build: 2381

Email Object Build: 2381

Geocoder Object Build: 2408

MatchUp Object Build: 2408

Database Date: 07/15/2014

Changes

• Changed option "Peroform WS Lookup" for Email Check to default to false.
• Fixed problem with Result Codes when switching from Community Edition to Full Version

Personator Component

Version: 1.0.0.2419

Changes

• Fixed a problem where some options were disabled in certain conditions.
• Pass-through data types now match exactly what is input.

SmartMover Component

Version: 1.0.1.2419

Changes

• GUI modifications
• Component now communicates with new v3 version of SmartMover web service.
• Added Canadian Change of Address processing via Canadian SmartMover web service.

Fuzzy Matching Component

Version 2.0.0.2419

Changes

• Added SSIS data type descriptions to ‘Options’ drop-down menu.

MatchUp Component

Version: 2.2.0.2419

Changes

• Added SSIS data type descriptions to ‘Options’ drop-down menu.

IPLocator Component

Version: 2.2.0.2419

Changes

• Initial Release

Build 4.2

Released May 2014

Compatibility Summary

The following DLLs are now being compiled in Visual Studio 2012:

• Address Object
• Name Object
• Phone Object
• Email Object
• Geocoder Object
• MatchUp Object

This requires the installation of the 2012 Visual C++ Redistributable which is included in the SSIS Installation.

Installer

The Setup will automatically install 2012 Visual C++ Redistributable (x86 and x64) for compatibility with VS 2012 Compiled DLLs.

Contact Verification Component

Version: 1.0.1. 2368

Address Object Build: 2362

Name Object Build: 2362

Phone Object Build: 2362

Email Object Build: 2362

Geocoder Object Build: 2362

MatchUp Object Build: 2362

Database Date: 04/15/2014

Changes

• Added additional option in the configuration file for DisableAddressSwapping. This option can be set to true in order to permanently disable the swapping of AddressLine1 and AddressLine2.

Personator Component

Version: 1.0.0. 2368

Changes

• Added ‘Freeform’ input address field option.
• Set maximum output field size to 255 instead of 256 (particularly problematic for Excel).
• Actions were sometimes unselected automatically.
• Pass-through columns were not always passing through data.
• Changed verification so that outputting just a result code is not an error.
• Pass-through's ‘Select All’ button didn’t always work.
• No default was selected for the Append options.

MatchUp Component

Version: 2.2.0. 2368

Changes

• Fixed a problem with date-distance matchcodes; dates with trailing spaces weren’t properly parsed.
• Fixed a problem with ‘Join with Spaces’ not properly working with an Intersection Lookup source.
• Fixed a problem where editing survivorship output column size was not getting saved.
• Survivorship mode ‘Average’ wasn’t working correctly for integers.

Global Verify Component

Version: 2.2.0. 2368

Changes

• Added Delivery Lines Option in the GUI for outputting the complete Global Mailing address in AddressLines 1 - 8.

Build 4.1

Released February 2014

Contact Verification Component

Version: 1.0.1.2313

Address Object Build: 2288

Name Object Build: 2288

Phone Object Build: 2288

Email Object Build: 2288

Geocoder Object Build: 2312

MatchUp Object Build: 2137

Database Date: 01/15/2014

Changes

• Added Congressional District output to MD Cloud mode processing.
• Updated GUI Display to properly reflect Geocoding level of accuracy when MD Cloud processing.

Personator Component

Version: 1.0.0.2313

Changes

• Fixed issues related to difficulties in the inputting of the License Key.
• Fixed Pass-thru All/None button.

MatchUpComponent

Version: 2.2.0.2313

Changes

• Added Survivorship processing option.
• Expression evaluator didn't recognize fields delimited with square brackets.

Build 3.5

Released November 2013

Installer Changes

• The following component is now included in the Data Quality Components for SSIS: Personator

Contact Verification Component

Version: 1.0.1.2280

Address Object Build: 2274

Name Object Build: 2274

Phone Object Build: 2274

Email Object Build: 2274

Geocoder Object Build: 2269

MatchUp Object Build: 2137

Database Date: 10/15/2013

Changes

• Fixed rare cloud bug where if an SE01 error did not return 100 records, an incorrect error message was relayed to user.
• Updated on-premise e-mail options to reflect new build (Fuzzy Lookup and Web Service Lookup options added).
• Fixed a problem where Input Company did not have a [None] option.
• Added SSIS variables: CASSFormProcessorName, CASSFormListName, CASSFormName, CASSFormCompany, CASSFormAddress, CASSFormCity,CASSFormState, CASSFormZip, SOAFormProcessorName, SOAFormAddress, SOAFormCity, SOAFormProvince, SOAFormPostalCode, SOAFormFileName
• Added ability to standardize Company names

Personator Component

Version: 1.0.1.2280

Changes

• Added New Personator Component

SmartMover Component

Version: 1.0.1.2280

Changes

• Added Community Edition mode, users can demo UI but cannot process.

Global Verify Component

Version: 1.0.1.2280

Changes

• Added Community Edition mode, users can demo UI but cannot process.

Build 08/2013

Released August 2013

Installer Changes

The DQC-web.exe Web Installer now installs a set of required data files:

• mdAddr.dat
• mdEmail.cfg
• mdEmail.dat
• mdName.cfg
• mdName.dat
• mdPhone.dat
• mdPhone.idx
• ZIPNPA.txt

Contact Verification Component

Version: 1.0.1.2233

Address Object Build: 2214

Name Object Build: 2214

Phone Object Build: 2214

Email Object Build: 2214

Geocoder Object Build: 2225

MatchUp Object Build: 2137

Database Date: 7/15/2013

Changes

• Added the Community Edition for non-licensed users.
• Added Company Standardization under the Name Tab
• Added new properties to the output CASS Form

Smart Mover Component

Version: 1.0.1.2233

• Fixed bug (first seen in SmartMover, but likely in all components), where on systems where a full BIDS install was not done, some of the .config settings were not getting loaded.

Build 05/2013

Released May 2013

Contact Verification Component

Version: 1.0.1.2182

Address Object Build: 2149

Name Object Build: 2149

Phone Object Build: 2149

Email Object Build: 2149

Geocoder Object Build: 2182

Database Date: 4/15/201

Changes

• Added MatchUp Community and MatchUp Lite Editions
• Fixed a bug where you couldn't select "Fixed Length Unicode" on the Default Column Types
• Fixed bug, in command-line runs Lookup stream sometimes was not getting records populated (you'd just get null fields).
• Fixed crash when processing with Lookup table and Golden Record.
• Fixed GUI anomaly, previous changes to Field Mappings would be forgotten if you re-entered that tab from another tab.
• Addresses that cannot be GeoCoded will now return a Latitude/Longitude of blank instead of zero (0).ed.
• Old Email Data Files are no longer supported.

Deprecated

• mdDomain.dat
• mdEmail.ini
• mdEmailConfig.ini

This release includes new data sets for Email and is not backwards compatible.

New Data Files

• mdEmail.dat
• mdEmail.cfg

It is required to update both the object and the data files for this update.

Build 02/2013

Released February 2013

Contact Verification Component

Version: 1.0.1.10

Address Object Build: 2085

Name Object Build: 2057

Phone Object Build: 2057

Email Object Build: 2057

Geocoder Object Build: 2134

Database Date: 1/15/2013

MatchUp Component

Version 2.1.0.2137

MatchUp Object Build

2137

Changes

• Added Golden Record capability to Options tab.
• Fixed crash when working with very large data sets and limited disk space.
• User may now specify where work files are stored in 'Advanced Configuration dialog.
• Improved matching speed in some situations.

Build 09/2012

Released September 2012

Intersecting deduper

Re-Worked Intersecting Deduper for improved performance

New Match Code Editor Interface

Simplified and improved the MatchCode Editor

Added Fuzzy Matching Algorithms

The following algorithms were added for fuzzy matching compatibility:

• N-Gram
• Jaro
• Jaro-Winkler
• Longest Common Substring
• Needleman-Wunsch
• MD Keyboard
• Smith-Waterman-Gotoh
• Dice’s Coefficient
• Jaccard Similarity
• Overlap Coefficient
• Double Metaphone

Added new Match Code Types

The following match code types were added to MatchUp:

• Proximity
• Numeric
• Date

2012 Compatibility

The Data Quality Components for SSIS is now available and supported in SQL Server 2012

New Global Component

Global Component for validating and correcting international addresses is now released for SQL Server 2005, 2008 and 2012.

Notice

2005 SSIS Components have been deprecated and are no longer fully supported.

Build 06/2012

Released June 2012

Compatibility Summary

Address: None. Object and Data file only update.

Name: None

Phone: None

Email: None

Installer

If the installer cannot recognize (or mis-recognizes) the version of SQL Server SSIS that you have installed, you can force it to install to a particular version with one of the command-line switches: /Force2005x32, /Force2005x64, /Force2008x32 or /Force2008x64. Only use one of these switches at one time. Often, the installer has recognition issues because a critical component of SQL Server may be missing (such as SSIS services). As a result, after forcing an install in this manner, you may have difficulties using the DQS components.

Contact Verification Component

Version: 1.0.1.9

Address Object Build: 1974

Name Object Build: 1974

Phone Object Build: 1974

Email Object Build: 1974

Geocoder Object Build: 1979

Database Date: 5/15/2012

Changes

• Added 'Report result codes for empty input' option to 'Output Filter' tab.
• User may now specify a proxy server on 'Advanced' dialog.
• Fixed bug: sometimes the Canadian Geocoding option wasn't getting recognized.

SmartMover Component

Version: 1.0.1.6

Changes

• User may now specify a proxy server on 'Advanced' dialog.

Fuzzy Matching Component

Version 2.0.0.10

Changes

• Minor name change.

MatchUp Component

Version 2.0.0.6

MatchUp Object Build: 1985

Changes

• Matchcode Editor is now fully integrated into component.
• Fixed bug, combination result codes not reported in all setup configurations.
• Fixed crash/hang in certain setup configurations involving passthrough fields.
• User may now specify where work files are stored in 'Advanced Configuration dialog.
• New matching data types: Geographic Proximity, Numeric Difference, Date Difference.
• New fuzzy matching rules: N-Gram, Jaro Distance, Jaro-Winkler Distance, Longest Common Substring, Jaccard Index, Dice's Coefficient, Overlap Coefficient, Needleman-Wunsch, Smith-Waterman-Gotoh, MD Keyboard, Double Metaphone.
• Improved matching accuracy in some situations.
• Improved matching speed in some situations.
• Eliminated certain matchcode requirements and restrictions that were previously required.
• Added 'Record Suppresion' processing mode.
• Added 'Record Intersection' processing mode.