I have a requirement of finding the recently modified/created file from a directory and rename it to a standard name run that file and then rename it back to previous name. How can this be achieved?
Steps needed to be achieved:
- finding the recently modified/created file
- rename that file to a standard name.
- run that file
- rename it back to previous name.
I used a script task to find the recent file, but i could not move forward. I tried many things. Any solution on how to implement this?
I used this blog to find the recently modified/created file - https://www.techbrothersit.com/2013/12/ssis-how-to-get-most-recent-file-from.html