Build History:SSIS:Data Quality Components
Jump to navigation
Jump to search
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.