You may wanna try to force the 32-bit runtime in Agent and try again. Note that if the row count matches then it'll be a driver/runtime mismatch, if not try to redirect error/truncation rows and capture what's being rejected. One final suggestion is to compare agent parameter values vs Designer.