December 11, 2009 at 8:55 am
My requirement is to copy files from this (https://citrix...... ) remote site everyday to our local server. As of now I am doing it manually.
Manual Steps:
Opening iexpore to log to the site
providing username and password
Going to F$
Looking for today's files...
Finally copying to my location.
Is there to automate this process using Command Prompt or any language ?
any help is really appreciated
December 12, 2009 at 12:44 pm
Is it through an http transfer or something other protocol?
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
January 6, 2010 at 7:29 am
I also need to do this (altough from another server)...any ideas anyone?
January 7, 2010 at 11:42 am
Hmmm ... you manually do the following:
Manual Steps:
Opening iexpore to log to the site
providing username and password
Going to F$
Looking for today's files...
Finally copying to my location.
Well for starters you can create a cmd script similar to the following:
ftp https://citrix...
user (your_username) (your_password)
ascii --> for text files, if they are anything like exe.s use binary
cd F$
lcd (your_location)
get (filename) --> or mget (filename_mask)
quit
The above is just a shell example. In order to fine tune the actual script you will have to start a cmd line ftp session and enter a question mark to get that sites specific ftp help. Once you have the script you can then schedule a task or a SSIS package. All it takes is a bit of tinkering.
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply