HI, I want to retreive multiple fields with about a bunch of joins and load it into a hash using cache teansform and use the cache as a look up to retreive required fields.. can any one plz suggest me an approach for the issue. I do not want to load the cache into a file. Thanks ...

You are simply populating a Cache Connection Manager with whatever using any number of joins, etc. Then you use the Cache Connection Manager as your source for a lookup transform. Check out: http://msdn.microsoft.com/en-us/library/bb895289.aspx. Check this video out (by Dan English): http://www.youtube.com/watch?v=GEloiitNtkURussel Loski, MCT