I am kinda stuck into a situation where i am planning to automate one manual process.
On the daily basis we get almost 7 files from another system and to process them we have to change there name to one specific name so that system can pick it up automatically.
For example :- Daily files name is
And to process these files in our application we have to change the file name to Sql.ipm
only and in particular location because our application is hard coded with this behavior.
My idea was to copy these files out side target folder and move these file one by one and rename them as they get moved in target folder so that they can be processed as per application requirements.
Here i am looking for a way to copy these file one by one and rename them as well once they are in target folder. Can we achieve this using the combination of sql and cmd.
Please do let me know please and Many Thanks in Advance for all you help.