Build History:SSIS:Data Quality Components: Difference between revisions

From Melissa Data Wiki
Jump to navigation Jump to search
← Older editNewer edit →
No edit summary
No edit summary
Line 7: Line 7:
: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.
: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
;Contact Verification Component  
:Version: 1.0.1.5009
:Version: 1.0.1.5009
:Address Object Build: 2961
:Address Object Build: 3067
:Name Object Build: 2961
:Name Object Build: 3067
:Phone Object Build: 2961
:Phone Object Build: 3067
:Email Object Build: 2961
:Email Object Build: 3067
:Geocoder Object Build: 2961
:Geocoder Object Build: 3108
:MatchUp Object Build: 5023
:MatchUp Object Build: 5023
:Database Date: 01/15/2018
:Database Date: 01/15/2018
Line 51: Line 51:
::::HouseholdSize - Returns the number of occupants in the household.
::::HouseholdSize - Returns the number of occupants in the household.
::::PoliticalParty - Returns an individual’s political affiliation.
::::PoliticalParty - Returns an individual’s political affiliation.
::::PresenceOfSenior - Returns the presence of senior/s in the household.
::::PresenceOfSenior - Returns the presence of senior(s) in the household.


::*Added the following output fields to the Personator Output Columns
::*Added the following output fields to the Personator Output Columns
Line 85: Line 85:
:Version 2.1.0.5014
:Version 2.1.0.5014
:Global Address Object Build: 2921 (32bit), 2921 (64bit)
:Global Address Object Build: 2921 (32bit), 2921 (64bit)
:Database Date: 10/15/2017
:Database Date: 10/15/2018


:;Changes
:;Changes
Line 91: Line 91:
:*New Feature:
:*New Feature:
::*Added output field
::*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.  
::::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
;IP Locator Component
Line 101: Line 101:


;Property Component
;Property Component
:Version 1.0.0.5021
:Version 1.0.0.5024


:;Changes
:;Changes


:*New Feature:
:*New Feature:
::*Added V4 LookupProperty Output Fields  
::*Added V4 LookupProperty Output Fields


:::;GrpParcel
:::;GrpParcel

Revision as of 22:21, 22 February 2018

← SSIS:Data Quality Components


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.5009
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.5013
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.5008
Changes
  • Added MoveTypeCode to output column
  • MoveTypeCode - Type of move (individual or business)
Fuzzy Matching Component
Version 2.0.0.5006
Changes
  • None
Matchup Component
Version 2.2.0.5013
Changes
  • Fixed Bugs:
  • Mappings reset when global matchcode components changed
Global Verify Component
Version 2.1.0.5014
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.5007
Changes
  • None
Property Component
Version 1.0.0.5024
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.5007
Changes
  • None
Businesscoder Component
Version 1.0.0.5011
Changes
  • None
Generalized Cleanser Component
Version 1.0.0.5006
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.
Retrieved from "http://wiki.melissadata.com/index.php?title=Build_History:SSIS:Data_Quality_Components&oldid=13903"