O'Reilly logo

SQL Server 2017 Integration Services Cookbook by Dejan Sarka, Matija Lah, Christian Cote

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

How it works...

At the beginning of the execution, all reference data about persons and companies is loaded into memory; this is reflected by the messages in the Output window: Company Lookup and Person Lookup. Reference sets are extracted during the data flow's Pre-Execute phase. Data processing in this data flow cannot commence until the lookup data is cached.

After the data is extracted from the source flat file, it is first checked in the Person Lookup transformation: matching rows are placed in the Lookup Match Output, and non-matching rows are placed in the Lookup No Match Output. Only unmatched rows from the Person Lookup transformation are then checked in the Company Lookup transformation and placed in the Lookup Match Output.

Because ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required