Please provide more detail about how Server D is executing an SSIS package on Server A. Unless I am missing something I didn't think this was possible unless you execute and SQL Agent Job on Server A remotely from Server D.