如何将文件从一个位置复制到另一个位置throgh sql。 [英] How to copy files from one location to another location throgh sql.
问题描述
我一直在尝试使用以下命令将文件从一个位置复制到另一个位置。但由于遇到错误，我无法成功执行..
exec master..xp_cmdshellnet use t：\\61.16.165.200\D $ \ EXPORTReport xitech123！/ user：ggsfadata\sfa / persistent：yes
exec master..xp_cmdshell'复制E：\ EXPORTReport \ *。* \\61.16.165.200 \D $ \ EXPORTReport'
exec master..xp_cmdshellnet use T：/ delete
i有以下错误列表..
1）系统错误53已经发生。
2）找不到网络路径。
3）E：\ ExportReport \ddd.txt
找不到网络路径。
0个文件被复制。
4）无法找到网络连接。
NULL
键入NET HELPMSG 2250可获得更多帮助。
NULL
NULL
请帮帮我......
I have been trying to copy files from one location to another location using following command..but am not able to execute it successfully due to error am encountering..
exec master..xp_cmdshell "net use t: \\61.16.165.200\D$\ExportReport xitech123! /user:ggsfadata\sfa /persistent:yes"
exec master..xp_cmdshell 'copy E:\ExportReport\*.* \\61.16.165.200\D$\ExportReport'
exec master..xp_cmdshell "net use T: /delete"
i have list of errors which follows below..
1)System error 53 has occurred.
2)The network path was not found.
3)E:\ExportReport\ddd.txt
The network path was not found.
0 file(s) copied.
4)The network connection could not be found.
NULL
More help is available by typing NET HELPMSG 2250.
NULL
NULL
Please help me out...
推荐答案
\ Exportport xitech123！ / user：ggsfadata\sfa / persistent：yes
exec master..xp_cmdshell'copy E：\ ExportReport \ *。* \\ 61.16 .165.200 \ D
\ExportReport xitech123! /user:ggsfadata\sfa /persistent:yes"
exec master..xp_cmdshell 'copy E:\ExportReport\*.* \\61.16.165.200\D
\ Exportport'
exec master..xp_cmdshellnet use T：/ delete< br $>
i有以下错误列表..
1）系统错误53已发生。
2）找不到网络路径。
3）E：\ EXPORTReport \ddd.txt
找不到网络路径。
0文件已复制。
4）无法找到网络连接。
NULL
输入NET HELPMSG可获得更多帮助2250.
NULL
NULL
请帮帮我......
\ExportReport'
exec master..xp_cmdshell "net use T: /delete"
i have list of errors which follows below..
1)System error 53 has occurred.
2)The network path was not found.
3)E:\ExportReport\ddd.txt
The network path was not found.
0 file(s) copied.
4)The network connection could not be found.
NULL
More help is available by typing NET HELPMSG 2250.
NULL
NULL
Please help me out...
这篇关于如何将文件从一个位置复制到另一个位置throgh sql。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
