Post reply

job which copies files based on date in the filename.

  • June 11, 2007 at 12:51 pm

    #117517

    hello all.

    i'm sure i'm not the only one who's looking for something

    like this, but i'm trying to create a job which will

    simply copy files from one folder to another based on

    the date YYYYMMDD which is included in the filename.

    basically if the YYYYMMDD is today, then copy files

    from here to there, if not, then do nothing.

    can this be done from an SQL job?

    any ideas?

    _________________________

  • June 12, 2007 at 8:14 am

    #712303

    Not sure why you would not consider a .bat( of dos commands) file or vb script file and use windows schedule tasks.

  • June 13, 2007 at 11:58 am

    #712705

    so by using a scheduled task i can parse the filename,

    and move the files based on that?

    for example: what if all files are named: MyFile2007050800.txt

    scheduled task will be able to see that date, and then move the

    file accordingly?

    _________________________

  • June 13, 2007 at 1:24 pm

    #712740

    You will either write a .bat file or a .vbs script file with all the logic of parsing the file. You can use notepad to create the scripts.

    This script will be scheduled windows schedule tasks.

  • June 14, 2007 at 4:38 am

    #712864

    I always use ROBOCOPY for this kind of thing. It was included in the resource kits for win nt and win 2000, I am not sure if it comes with 2003 anymore, but you should be able to find it.

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

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