SQL and Does Comands

• rhunt

  SSCertifiable

  Points: 5868

  More actions

  September 21, 2005 at 11:23 am

  #91309

  I have a interesting requirement that may or may not be able to be fullfilled using sql extended stored procedures like xp_cmdshell.  I'm not familiar with these XSP's so I figured I'd drop it by the list...

  I need to examine many directories and move their contents to other directories on a schedule.  At first I was simply going to use some combination of  DOS's XCOPY, DELETE/ERASE, or MOVE commands.  However, there is one requirement for my problem that these DOS commands can't accomodate.

  I need any files that are currently in use NOT to be moved from the source directory. 

  Has anyone encountered anything similar and solved it with SQL?  I ask because I am most familiar with SQL.  However, if anyone has another suggestion on another language that might be able to do this, please let me know.

  Thanks in advance.

  Ryan

• Ian Scarlett

  SSC-Insane

  Points: 23197

  More actions

  September 22, 2005 at 1:22 am

  #592097

  Have alook at this post:

  http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=220567