Cache and Lookup example
Cache transform in SSIS
This example show you how to use cache transform in ssis.
1.The first you need to create a new Data Flow task
2.Then you need to create a data source (Flat File source). Drag-and-drop Flat file Source component from the SSIS Toolbox.
3.Now configure new flat file connection manager and select data source file.
4.Source file must contains at least 2 fileds: id and other different data field. You can use source file similar to this
5.Press OK. The next step you need to drag-and-drop Cache Tranform to the Data Flow.
6.Open settings (two click on the component icon) and press "New" to create new Cache connection manager.
7.In opened window you need to select local cache file
8.Navigate to the Mappings tab and connect needed relationships
Congratulation! You have been successfully configured Cache transform.
Lookup transform in SSIS