Ok, The xp_cmshell did work. Unfortunately while naming my file name I accidently placed a space and that was why sql could not find it. But thank you guys for...

The D: drive is local drive and that is why I don't understand why it does not work. I even copied the  batch file to c: root but still it...

I have been trying to do the same thing in last few days but no luck. I am afraid the just executing following command does not work

exec master..xp_cmdshell  ...