MY OLD SITUATION:
My company has a Coldfusion website, hosted by a local ISP, and each night I have a Windows Scheduled Task that uploads (ftp) the website's Access data source.
MY NEW SITUATION:
Recently, we purchased our own IBM webserver (using Server 2003, Coldfusion MX 6.1), but It is still located at our ISP's offices (for security reasons). I am told that now rather than FTPing my data source, I must use Windows Remote Desktop Connection (terminal services) to connect to the web server. I have the connection established - I log on with a u-name & p-word - then the server's desktop is displayed & I can transfer files from my local conmputer to the server.
WHAT I NEED HELP WITH
I need to make my new situation an automatic process that also occurs at night - that is, my data source gets transfered to my remote web server each night. I am told by a contact at my ISP that this could be very difficult to set a Scheduled Task to log onto my remote web server, transfer the files, then log off.
I have absolutely no idea where to start! First, is this even possible? Can someone point me in the correct direction as to what I need to know/learn to be able to accomplish this process? Can I accomplish this using VB?
Any help/input would be greatly appreciated.