• 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