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...

In the control flow of the LookupCache.dtsx SSIS package, you changed the way the person reference data is cached; instead of relying on the Person Lookup transformation to load the data into cache, you decided when the data is going to be cached.

In the Output window, you can see that the person reference data was cached only once, whereas the company reference data was cached for each file processed by the Foreach File container—that is, altogether three times.

Once populated, the cache object can be used multiple times in the same package, in the execution in which it was populated. Alternatively, the cache object can also be configured to store the cached data in a file; once populated, such a file can even be used by ...

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