Using xp_cmdshell to copy files

[LonnieJohnson]

I am writing a script for a trigger that will copy some files if a client record is closed when a certain date is entered. The code below works fine except for my subfolders.

Is there an easy way to copy those as well without getting into complicated recursive code?

If not, does anyone have any sample code?

Exec master.dbo.xp_cmdshell 
'Copy \\profile-ks-001\pool\Client_Files\test1\*.* 
\\profile-ks-001\pool\Client_Files\test2\*.*' 
Go

Thanks in advance.

ProDev, Builders of Affordable Software Applications
Visit me at ==>

http://www.prodev.us

May God bless you beyond your imagination!!!

 

[Crowley16]

erm, you could use xcopy instead of copy.

I'm assuming you're aware of all the security implications of allowing xp_cmdshell...

--------------------
Procrastinate Now!

 

[bouwob]

robocopy would also be of use.