I have a package with five data flow task.Inside each data flow task there are lookups and the lookups are configured as Full cache. My doubt is ,will all the cache mentioned in each data flow task will be loaded to cahce before the package starts executing. or else when executing the first data flow task,the lookup inside that data flow task will only be loaded and after completing the execution of first data flow task,the lookup inside the second data flow task will be loaded to cachefuzailrashid

Full Cache will be loaded during pre execute phase.Cheers , Varun

Each cache is loaded prior to the containing dataflow executing, not prior to the package executing. Hence, if Dataflow2 starts after Dataflow1 has completed any Lookup caches in Dataflow2 will also not get populated until Dataflow1 is complete.http://sqlblog.com/blogs/jamie_thomson/ | @jamiet | About me

It is during the pre-execute phase of the data flow task ,the data is loaded into cache. However , when I run two data flow tasks in parallel, the reference datasets are cahced in parallel , an observation. Happy to help! Thanks. Regards and good Wishes, Deepak.