Post reply

How to find files and move...

  • March 25, 2003 at 9:35 pm

    #79751

    I query a list of log files from a table and need to find them in a direcotry (c:\Log\) and move them to a central location. Does anynoe had experience?

    Thanks

  • March 26, 2003 at 1:59 am

    #452148

    The two options that spring to my mind are:

    (1) Use a DTS job.

    (2) use the extended stored procedure master..xp_cmdshell to run appropriate DOS commands. If you're not familiar with it, there are some good articles about this procedure within this site

    Thomas Rushton
    blog: https://thelonedba.wordpress.com

  • March 26, 2003 at 8:27 am

    #452191

    I would suggest if doing it in a DTS package to use a VBScript step with the Scripting.FileSystemObject. There are MANY examples of doing what you asked for on Microsofts scripting site. See :

    http://msdn.microsoft.com/library/default.asp?url=/library/en-us/script56/html/jsfsotutor.asp

    Tim C.

    //Will write code for food


    Tim C //Will code for food

  • March 26, 2003 at 8:36 am

    #452192

    Thanks, Thomas,

    I found the related article using xp_fileexist.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply