|
|
| (58 intermediate revisions by the same user 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.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 depreciated 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
| |
| | |
| :;Change
| |
| | |
| :*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 depreciated
| |
| :*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
| |
| :{|class="alternate01" cellspacing="0"
| |
| !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.
| |
| | |
|
| |
|
| [[Category:Build History]] | | [[Category:Build History]] |
| [[Category:SSIS:Data Quality Components]] | | [[Category:SSIS:Data Quality Components]] |