|
|
| (75 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 5.3==
| |
| ''Released August 2015''
| |
| *Coming Soon
| |
| | |
| ==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]] |