SSIS:MatchUp Editions
Jump to navigation
Jump to search
← SSIS:Data Quality Components
The MatchUp Component for SSIS has three different editions. Each edition has a different level of utility, with the Professional edition offering the full functionality of MatchUp.
The following chart displays the level of utility of each edition.
Edition | Community Edition | Lite Edition | Standard Edition |
---|---|---|---|
Available Matchcodes | Address | Address | Address |
Address, Last | Address, Last | Address, Last | |
Address, Last, First | Address, Last, First | Address, Last, First | |
Address, APT | Address, APT | Address, APT | |
Address, APT, Last | Address, APT, Last | Address, APT, Last | |
Address, APT, Last, First | Address, APT, Last, First | Address, APT, Last, First | |
Address, Fuzzy Last | Address, Fuzzy Last | Address, Fuzzy Last | |
International Address | International Address | International Address | |
General (40) | General (40) | General (40) | |
Address, Last Name, Gender | Address, Last Name, Gender | ||
Address, Company | Address, Company | ||
Address, Company AND Last Name | Address, Company AND Last Name | ||
Address, Company AND Last Name, First Name | Address, Company AND Last Name, First Name | ||
Address, Company OR Last Name | Address, Company OR Last Name | ||
Address, Company OR Last Name, First Name | Address, Company OR Last Name, First Name | ||
United Kingdom Address | United Kingdom Address | ||
Address, Fuzzy Last Name, Init First Name | Address, Fuzzy Last Name, Init First Name | ||
Address, Fuzzy Last Name, Nickname | Address, Fuzzy Last Name, Nickname | ||
Name, Address, Proximity Match | Name, Address, Proximity Match | ||
Custom Matchcodes | No | No | Yes |
Record Limit | 50,000 | 1,000,000 | Unlimited |
License Required | No | Yes | Yes |