Did you try put flat file on sql server's local disk and let ssis get that local file instead of transfer? Does sql agent service account have proper permission to use Dynamics GP?