Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
benni
Starting Member
4 Posts |
 Posted - 2011-04-28 : 15:25:33
|
| Hi, I have to schedule a batchfile in sql server 2005 to copy files from one server to another remote server.I'm using the below statement and it is not happening the process.And, to login to server2 i have to use username and password. so , how could i add the username and password in the below statement to auto processit. Is the statement enough to do the process.Please help. thanks.xcopy /e /v /y \\server1\Prod_Output\New_files //server2/Docs/Reports/FTPfolder |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
benni
Starting Member
4 Posts |
Posted - 2011-04-28 : 15:49:55
|
| Thanks and is this syntax correct ?CPAU \\server1\Prod_Output\New_files\*.* -u server2\UserName -p password -ex \\Docs\Reports\FTPfolder or is there any way can i pass the username/password in the xcopy command. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
benni
Starting Member
4 Posts |
Posted - 2011-04-28 : 16:57:26
|
| Thanks a lot and i'm trying it , i would let you know .... |
|
|
|
|
|
|
Batchfile