KingswaySoft

SSIS Premium Lookup Component

Easily perform exact or fuzzy lookups in SSIS with any data input

KingswaySoft

Premium Lookup Component

The Premium Lookup component combines the native SSIS Lookup & Fuzzy Lookup components to give developers one easy to use component that will meet all their SSIS lookup transformation needs without any limitations.

The Premium Lookup component part of the SSIS Productivity Pack offers all the functionality of the SSIS out-of-box Lookup & Fuzzy Lookup components and expands on these features to offer the capability to use any data input as the lookup source and simplifies development workflow by only needing to configure one component to perform an SSIS Lookup or Fuzzy Lookup.

With advanced Match types, the SSIS Premium Lookup components enables developers to select if the lookup is a First Name, Phone Number, Street Address, US Zip Code or Company Name, these matched can be exact or fuzzy. With these advanced match types, 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 Derived Column

Try it now for Free

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

Download the SSIS Productivity Pack with the Premium Lookup now for free