Last time I got this error - also quite randomly - I got it resolved by adding more memory to the server.
It seems a bit counter intuitive, but I did some research and it is possible that because of memory pressure an issue might occur when transfering data.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP