cache connection manager editor
In the cache connection manager editor under columns tab there is column named "index position". what is the significance of the index position column?
July 13th, 2011 12:37am
When the Lookup transformation is configured to use a Cache connection manager, only index columns in the reference dataset can be mapped to input columns. Also, all index columns must be mapped.
reference:
http://msdn.microsoft.com/en-us/library/bb895364.aspxhttp://www.rad.pasfu.com
My Submitted sessions at sqlbits.com
Free Windows Admin Tool Kit Click here and download it now
July 13th, 2011 12:45am
thanks reza raad
July 13th, 2011 1:24am