The Cache connection manager reads a reference dataset from the Cache transform or from a cache file (.caw), and can save the data to a cache file. The data is always stored in memory.
- The Cache connection manager does not support the Binary Large Object (BLOB) data types DT_TEXT, DT_NTEXT, and DT_IMAGE
Specify which columns are index columns by specifying the index position of each column. The index is a collection of one or more columns.
For non-index columns, the index position is 0.
For index columns, the index position is a sequential, positive number. This number indicates the order in which the Lookup transformation compares rows in the reference dataset to rows in the input data source. The column with the most unique values should have the lowest index position.
The column which we specified as index Position, those all should be used as lookup search.
If you configure the cache connection manager to use a cache file, the connection manager will do one of the following actions:
- Save data to the file when a Cache Transform transformation is configured to write data from a data source in the data flow to the Cache connection manager. For more information, see Cache Transform.
- Read data from the cache file.
Hi,
ReplyDeleteThe above article way of writing is very good and sentences are easy to understand.
You can choose Script Component as a Source, a transformation, or a destination. The choice of function and the metadata and properties you configure in the editor results in creation of different members of the base classes in the auto-generated code. The Script Task does not provide any such facility, as the code generated is always the same.
nice explanation....you can elaborate the saving data to caw file in more details..
ReplyDeletethanks
http://www.redbushtechnologies.com/msbi-online-training.php
Thank you so much for providing exquisite base for solutions to various level of complicated IT problems.This indded turns out to be useful for professionals everytime.
ReplyDeleteSSIS Postgresql Read