Hi all,
I need to do the following and i was wondering if i could get some of your input. Every night there is a file created at a certain location (on a ftp server). What i need to do is download this file and import it into a remote sql server via web services. I also need to have the ability to re-run the import process (download file and send contents to server) at any time manually. I figured a windows service would be good for this, but i don't see how i can manually re-run the import process at any time. Has anyone done anything similar to this. If so, what was the technique you used?
Thanks