2 hours for 5 times 300.000 rows is slow. (ok, 8 hours is even slower)
What are you doing inside the package?
Regarding the error: PRIMARY filegroup has nothing to do with memory. The filegroup is where your database pages are saved unto disk. Your destination database has run out of size. Either there's a maximum size defined for the database, or you've run out of disk space.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP