Thanks for your inputs.

We are using SSIS 2005 and loading data on monthly basis. In lookups, we are not setting the Caching in the lookups. 3-4 dimensions are having...