I am running triggers on my server that are set off when certain text files are FTP'd to a default directory I have set up. What I want to be able to do is move these files to another directory after the trigger has fired. Here is a workflow:
1.) Text file(mlb_boxscore12.txt) is FTP'd to the D drive on my server.
2.) At 4:00 p.m., I have a trigger set up that runs for this file and outputs it to a web site.
After it is outputted to the web site I have no use for it in this directory. I would really like it moved to another folder on a seperate drive. What would be the best way of doing this?