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

From Melissa Data Wiki
Jump to navigation Jump to search
Oscar (talk | contribs)
Replaced content with "← SSIS:Data Quality Components {{CustomTOC}} Please visit Melissa’s Release Notes page for the latest SSIS updates and Build History: https://releasenotes.melissa.com/enterprise/dqc-ssis/#build-history. Category:Build History Category:SSIS:Data Quality Components"
Tag: Replaced
 
(63 intermediate revisions by 2 users not shown)
Line 1: Line 1:
[[SSIS:Data Quality Components|← SSIS:Data Quality Components]]
[[SSIS:Data Quality Components|← SSIS:Data Quality Components]]
{{CustomTOC}}
{{CustomTOC}}
 
Please visit Melissa’s Release Notes page for the latest SSIS updates and Build History: https://releasenotes.melissa.com/enterprise/dqc-ssis/#build-history.
==Build 6.1==
;''Released February 2016''
 
;Contact Verification Component
:Version: 1.0.1.2729
: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.2729
 
:;Changes
:*Move Default Set to Strict
 
;SmartMover Component
:Version: 1.0.1.2683
 
:;Changes
:*None
 
;Fuzzy Matching Component
:Version 2.0.0.2683
 
:;Changes
:*None
 
;MatchUp Component
:Version 2.2.0.2683
 
:;Changes
:*Various bug fixes.
 
;Global Verify Component
:Version 2.0.0.2683
:Global Address Object Build: 2620 (32bit), 2600 (64bit)
:;Changes
:*None
 
;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
:*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.
 


[[Category:Build History]]
[[Category:Build History]]
[[Category:SSIS:Data Quality Components]]
[[Category:SSIS:Data Quality Components]]

Latest revision as of 00:15, 30 December 2022

← SSIS:Data Quality Components


Please visit Melissa’s Release Notes page for the latest SSIS updates and Build History: https://releasenotes.melissa.com/enterprise/dqc-ssis/#build-history.