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

From Melissa Data Wiki
Jump to navigation Jump to search
No edit summary
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
 
(52 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 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.
:::{| class="alternate01"
!Option Name !! Parameter !! Description
|-
|TimeToWait|| <code>#[5-45]</code> || 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.
 
:::{| class="alternate01"
!Option Name !! Parameter !! Description
|-
|TimeToWait|| <code>#[5-45]</code> || 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
:{|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 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.
 


[[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.