SSIS

[SSIS] Lookup Transformation – Full Cache option

Level: Intermediate Lookup transformation is an essential ingredient of a Data Flow task accessing multiple database servers. I always use the Full Cache option when the reference table is small enough to be stored in memory. However, this caching option needs more than setting up your Lookup task to work. Here are few things to… Continue reading [SSIS] Lookup Transformation – Full Cache option