sql server no cache

16

Dec'13

SQL Server Lookup Transformations: Cache Modes (Part 1/2)

In Microsoft SQL Server Integration Services 2012 (SSIS) Lookup Transformations can be used to integrate external data into your Data Flow. While most Lookup Transformations in SSIS are relatively simple, it is important to know how they work and which situations to use them in. In this entry, we will focus on the cache modes of this transformation. There are three modes of caching in the Lookup Transformation: Full, Partial, and None.

Read More