May 14, 2009 at 8:27 am
I knw this is not a SQL question but I know there is a lot of knowledgeable people on this forum which mabe able to point me in the right direction.
I'm looking for an application/utility which copies, moves and delete files from a local directory or FTP site.
The Utility should be able to:
- scheduled to run
- locate files based on dynamic file names i.e. KeyNotes-20090513.txt file name will change based on date.
Is there an application which can do this?
May 14, 2009 at 1:53 pm
Couldn't you go old school and use a .bat file for this and have it scheduled via the scheduler of your choice (SQL Agent, Task Scheduler)?
A.J.
DBA with an attitude
May 14, 2009 at 1:58 pm
I would also use old-school batch files (or new-school power-shell files).
If you want to use a tool try FileZilla.
Greets
Flo
May 15, 2009 at 1:50 am
Thanks for the suggestions.
I am currently using VBScripts to copy & move files, this works well but I now have about 32 files and associated scripts which are scheduled through Windows Scheduled Task.
The problem is that the amount of scripts needs is forever growing and is now becoming a bit of a mess. Plus there is only 2 of us which know VB so if for any reason we are not here there will be a problem.
Im looking for a nice GUI interface application which all can use.
May 15, 2009 at 2:52 am
Either change the functionality of your VB-Scripts to work with config-files instead of copying around or have a look to SSIS.
Greets
Flo
May 15, 2009 at 3:06 am
I have a mixture of VB and SSIS packages doing these jobs....
BUT i want to get away from all of this, I have non tech people working on my team which cant handle this.
I dont mind paying for an App.....
The search continues
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply