Cache Connection Manager in SSIS
The Cache Connection Manager in SSIS is 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: Please refer to the Lookup Transformation in Full Cache Mode article to understand how to use the Cache file in Lookup Transformation in SSIS. Configuring … Read more
