This is generally because of some formatting problem of some columns in the sql.
1. Try with limited load.
2. If result is same try to eliminate the columns to see which one is problematic.
Another cause might be related to timeout or network problems. If you can trace it on source side, try to do so to locate the problem. Maybe it's rejected by source. That's also possible, looking at the error.