Premium Lookup Component

via SSIS Integration Toolkit

Premium Lookup is a flexible SSIS data flow transformation from the KingswaySoft SSIS Integration Toolkit. It can run exact and fuzzy lookups against almost any data source. It combines the built-in Lookup and Fuzzy Lookup components into one easy-to-use tool.

  Download    Purchase 
Premium Lookup Component by KingswaySoft

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 Integration Toolkit, 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').

SSIS Premium Lookup

Feature Out-of-Box Lookup Component Out-of-Box Fuzzy Lookup Component Premium Lookup Component

Lookup Column


OLE DB Only


OLE DB Only


Any Data Input

Combine Fuzzy & Exact Lookups


No


Yes


Yes

Simplified development processes.

Advanced Matching Types


No


No


Yes

SSIS Premium Lookup Fuzzy Lookup

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


Yes

Select the appropriate match type, similarity score and settings for each lookup column all within the main grid.

Different Data Types or Lengths


No


No


Yes

Advanced flexibility and data type handling allows developers to preform lookup between different data types or data type lengths.

Configure Output Columns


No


No


Yes

SSIS Premium Lookup column output

Error Handling

  • Fail on error
  • Ignore error
  • Redirect to output


Yes


No


Yes

Outputs


Matched & Unmatched Rows


Single Output


Matched & Unmatched Rows

Comparison Flags


No


Yes

  • Ignore Case
  • Ignore kana type
  • Ignore nonspacing characters
  • Ignore character width
  • Ignore symbols
  • Sort punctuation as symbols


Yes

  • Trim Leading and Trailing Whitespace
  • Ignore Case
  • Ignore All Whitespace
  • Ignore All Punctuation
Comparison Settings


No


Yes

  • Max number of matches


Yes

  • Max number of matches
  • Culture Identifier

Premium Lookup Component
is available in the
SSIS Integration Toolkit

DownloadPurchaseHelp Manual

Premium Lookup Component

Premium Lookup is a powerful SSIS data flow transformation for exact and fuzzy lookups against almost any data source. It avoids the limits of the built-in Lookup and Fuzzy Lookup components. Built on Microsoft SQL Server Integration Services (SSIS), it helps developers work faster with familiar tools, advanced match types, better data type handling, and clear comparison settings. Its drag-and-drop design makes complex lookups easy to set up.

Our Premium Lookup component is available within the Premium Data Flow components of our SSIS Integration Toolkit, 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 connect with different services during the ETL process. Each component is built to expand and improve data migration and integration work. In addition to Premium Lookup, the Premium Data Flow components include:

SSIS Premium ADO.NET Connector
Premium ADO.NET
SSIS Premium Aggregate Connector
Premium Aggregate
SSIS Premium Conversion Connector
Premium Conversion
SSIS Premium Derived Column Connector
Premium Derived Column
SSIS Excel Connector
Premium Excel
SSIS Premium OData Connector
Premium OData
SSIS Premium PDF Source Connector
Premium PDF Source
SSIS Premium Recordset Source Connector
Premium Recordset Source
SSIS Premium Service Lookup Connector
Premium Service Lookup
SSIS Premium Slowly Changing Dimension Connector
Premium Slowly Changing Dimension

Client Feedback

"KingswaySoft's SSIS Integration Toolkit has made a huge difference in how smoothly these integration projects can be delivered. It gives me the control and flexibility to handle larger data volumes and troubleshoot integrations as needed. In particular, Premium Lookup helps deal with common data inconsistencies and reduces manual cleanup, which saves time and makes the overall integration process much easier to manage."


Howdang RashidPower Platform & Data Architect

Read Case Study

Get In Touch

If you would like to know more specific details about our solutions, or if you have any suggestions about our product offerings, we are always here to listen and help!

Contact Us