Cache Connection Manager in SSIS

Cache Connection Manager in SSIS 5

The Cache Connection Manager in SSIS used in the Cache Transformation. Lookup Transformation uses this connection manager to perform lookup operations using the cache file. Cache Connection Manager in SSIS performs 2 operations: Cache Connection Manager reads data from the Cache Transformation and saves the data in the cache file with an extension of .caw. This Transformation … Read more