Premium Lookup Component

via SSIS Productivity Pack

A flexible way to perform lookup against any data sources. The Premium Lookup component combines the functionality of the out-of-box Lookup and Fuzzy Lookup components into one simplified, easy to use component, found withing the SSIS Productivity Pack.

Download Purchase

What other applications can you sync with Premium Lookup?
Click here for more solutions.

With Premium Lookup component, developers can use any data input as the lookup source and allows 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').

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 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
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 Productivity Pack

Download Purchase Help Manual

Premium Lookup: Data Integration Made Easy

Our solution is easy to use, offering code-less integration between the Premium Lookup components and virtually any other application or database system. Our solution is built utilizing Microsoft SQL Server Integration Services (SSIS), a performant and flexible ETL platform, allowing your team to take advantage of the technologies and skills they already have. The drag-and-drop user interface makes it easy to set up powerful integration within a matter of 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: