Hello, I'm trying to setup a task in SSIS to transfer a file generated by a client machine to a directory on the server. The client machine puts it on the local c:\ partition. I'd like the package to grab this file and put in on the server.
The file name will vary depending on the time it is run. So for example, the file can be named:
This file is time stamped with a date of 20150709 at 12:11. What is the best way to have my SSIS package grab the latest file in this directory, move it to my server, then archive it?
Thanks so much for your assistance.