How do I copy a file using xp_cmdshell
From: Vincel2k2 (Vincel2k2_at_discussions.microsoft.com)
Date: 02/11/05
- Next message: Brad White: "Re: ADO initialization fails on W2003"
- Previous message: Aaron Weiker: "Re: Stored Procedure Owner Issue"
- Next in thread: Andrew J. Kelly: "Re: How do I copy a file using xp_cmdshell"
- Reply: Andrew J. Kelly: "Re: How do I copy a file using xp_cmdshell"
- Reply: Jacco Schalkwijk: "Re: How do I copy a file using xp_cmdshell"
- Reply: Tibor Karaszi: "Re: How do I copy a file using xp_cmdshell"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 11 Feb 2005 06:29:02 -0800
Things I have tried.
xp_cmdshell "Copy D:\Database\Apps\Ven.mdb D:\ultradb\Ven.mdb"
This Works Great
xp_cmdshell "Copy X:\MMS\Data1\Log_data.mdb D:\ultradb\ Log_data.mdb"
Returns this error: The network name cannot be found. The path and filename
are correct
xp_cmdshell "Copy \\SERVER01\DATA\SHARED\WORK\MMS\Data1\ Log_data.mdb
D:\ultradb\ Log_data.mdb"
Returns this error: The network name cannot be found. The path and filename
are correct
EXEC xp_cmdshell ‘Copy \\SERVER01\DATA\SHARED\WORK\MMS\Data1\ Log_data.mdb
D:\ultradb\ Log_data.mdb
Returns this error: The network name cannot be found. The path and filename
are correct
- Next message: Brad White: "Re: ADO initialization fails on W2003"
- Previous message: Aaron Weiker: "Re: Stored Procedure Owner Issue"
- Next in thread: Andrew J. Kelly: "Re: How do I copy a file using xp_cmdshell"
- Reply: Andrew J. Kelly: "Re: How do I copy a file using xp_cmdshell"
- Reply: Jacco Schalkwijk: "Re: How do I copy a file using xp_cmdshell"
- Reply: Tibor Karaszi: "Re: How do I copy a file using xp_cmdshell"
- Messages sorted by: [ date ] [ thread ]