Premium Lookup Component
via SSIS Productivity Pack
A flexible way to perform lookup against any data sources. Premium Lookup combines the functionality of the out-of-box Lookup and Fuzzy Lookup components into one easy to use component.
Download Purchase
What other productivity components and tasks are included?
Click here for more solutions.
Data Integration Made Easy
Premium Lookup Component
Premium Lookup enables you to use any data input as the lookup source, allowing for several additional matching options without any deployment limitations.
With advanced match types, the Premium Lookup component, part of the SSIS Productivity Pack, enables developers to select if the lookup is a First Name, Phone Number, Street Address, US Zip Code or Company Name, and these matched can be exact or fuzzy.
Furthermore, the component will find matches for scenarios such as a full first name matching to a common nickname (ex: 'Bill' matches 'William') or an address with an abbreviation will match with the full spelling (ex: 'Av' matching to 'Avenue').
| Feature | Out-of-Box Lookup Component | Out-of-Box Fuzzy Lookup Component | Premium Lookup Component |
|---|---|---|---|
|
Lookup Column |
|
|
|
| Combine Fuzzy & Exact Lookups |
|
|
Simplified development processes. |
| Advanced Matching Types |
|
|
In addition to Exact and Fuzzy Match types, the component also offers First Name Match, Phone Number Match, Street Address Match, US Zip Code Match, and Company Name Match |
| Fuzzy Lookup Settings |
No |
Yes |
Select the appropriate match type, similarity score and settings for each lookup column all within the main grid. |
| Different Data Types or Lengths |
|
|
Advanced flexibility and data type handling allows developers to preform lookup between different data types or data type lengths. |
| Configure Output Columns |
|
|
|
|
Error Handling
|
|
|
|
| Outputs |
|
|
|
|
Comparison Flags |
|
|
|
| Comparison Settings |
|
|
|
Premium Lookup Component
is available in the
SSIS Productivity Pack
Premium Lookup Component
Premium Lookup is a powerful and flexible SSIS data flow transformation designed to perform both exact and fuzzy lookups against virtually any data source, without the deployment limitations of the out-of-box Lookup or Fuzzy Lookup components. Built on Microsoft SQL Server Integration Services (SSIS), it enables developers to work efficiently using familiar tools while benefiting from advanced matching types, enhanced data type handling, and configurable comparison settings. Its intuitive drag-and-drop interface makes it simple to set up complex lookups in minutes.
Our Premium Lookup component is available within the Premium Data Flow components of our SSIS Productivity Pack, a large collection of premium and unique ETL tools to enable greater development productivity. We also offer several additional connectivity solutions to easily integrate Premium Lookup with applications such as Microsoft Dynamics 365, SharePoint, Salesforce, and many more.
See our full product offerings for more information.
More Premium Data Flow Components
Our Premium Data Flow components make it easy to integrate with different services within the ETL process. Each component available has been specifically developed to expand and enhance data migration and integration processes. In addition to Premium Lookup, the Premium Data Flow components include:
Premium ADO.NET
Premium Aggregate
Premium Conversion
Premium Derived Column
Premium Excel
Premium OData
Premium PDF Source
Premium Recordset Source
Premium Service Lookup
