I don't really have a answer for you but I've seen this sort of thing on the forum before. The consensus seems to be that it's not a pure RAM issue but a SSIS package architecture/configuration issue.

Can you alter the package to process the data in chunks? Can you try a SQL Server provider rather than OLEDB?

Have you enabled logging in the package to get more detailed messages?

Maybe someone else can help more.