adamfewtrell (4/21/2016)
I understand your suggestion regarding columns. We got round this one-off testing problem by borrowing a server with 128GB of memory.However, I was really trying to understand the figures the message was reporting, particularly the paging file size, and I'm still no closer to that.
Okay,
I'm saying that your issue is that you are running out of memory. Entire books have been written about this subject. This is an SSIS board; if you want to learn about the specifics of memory then I'd suggest reading one of these books. Remember, nobody here is sat peering over your shoulder and since you have provided very scant details regarding your actual data flow, people have to use their experience. It's my experience that in 99% of the cases where you get this sort of error it can be resolved by tuning the SSIS package in some way. I was giving a suggestion as to where to start; this too is a big subject which I provided links for you to research further. It's great that you have resolved your issue by borrowing a server, but what happens when your data grows and that runs out of memory?
Good luck 🙂