Build History:SSIS:Data Quality Components: Difference between revisions
Jump to navigation
Jump to search
Line 48: | Line 48: | ||
:*International Matchup capabilities now added to Matchup Component | :*International Matchup capabilities now added to Matchup Component | ||
:*Community edition now requires a community edition license key, rather than no license key | :*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 an issue where users would experience field mapping issues in a matchcode (address 4-8) | ||
:*Fixed database expiration issue | :*Fixed database expiration issue |
Revision as of 23:53, 4 January 2016
← SSIS:Data Quality Components
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.