SSIS Package Memory Issue
There may be several reasons:


Check if the Page file for the system is configured properly, you might get this error if there is no page file or if page file is very small
Change the lookup cache mode from Full to Partial or no cache mode.
Migrate to 64-Bit SSIS if you are in 32-BIT. Remember you have to migrate all the drivers and providers used in connections. If you are in 64 BIT system and getting above errors while executing packages from BIDS then check if you have set package to run in 64bit run time ( Run64bitruntime = True in  Integration services project properties page).
Divide the package in to multiple child packages (Execute package task –> ExecuteOutOfProcess =True)
Tweak DefaultBufferMaxRows and DefaultBufferMaxSize size.


I hope that it helps.