When the package runs on the server it does not have access to your drives. Does D:\MyFiles exist on the server?
If you want more help zip your SSIS package and attach it to this thread (see "Edit Attachments" button).
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato