Build History:SSIS:Data Quality Components

← SSIS:Data Quality Components

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 string, 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 string.
• 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.