VBscript on MS Server 2003

[JV28132]

Can a vbscript movefiles from one place to another when it is executed on SQL Server 2003?

 

[markdmac]

Sure why not? You might want to script the use of ROBOCOPY to have more advanced copy options. Something like this:

Set WSHShell = CreateObject("Wscript.Shell")

SourceDir = "C:\Test1"
DestDir = "C:\Test2"

WSHShell.Run "CMD.EXE /C ROBOBCOPY " & SourceDir & " " & DestDir & " " & "/S /E /XO /R:0 /W:0"

I hope that helps.

Regards,

Mark

Check out my scripting solutions at

http://www.thespidersparlor.com/vbscript

Work SMARTER not HARDER. The Spider's Parlor's Admin Script Pack is a collection of Administrative scripts designed to make IT Administration easier! Save time, get more work done, get the Admin Script Pack.