Re: copy a file with xp_cmdshell

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: reddy (reddy_at_discussions.microsoft.com)
Date: 06/29/04


Date: Tue, 29 Jun 2004 07:25:01 -0700

hi friends,
i tried all your suggestions.but not working for me.
i am getting the follwing errors
if i use copy
EXEC master..xp_cmdshell 'xcopy \\e-060\c\updates.txt d\upd.txt'
Invalid drive specification
if i use xcopy
EXEC master..xp_cmdshell 'xcopy \\e-060\c\updates.txt d\upd.txt'
Logon failure: unknown user name or bad password.

plase suggest if any otherways are there to copy the files

thanks&regards
reddy