Toad Data Point version: 18.104.22.1688 (32 bit)
Im trying to copy an excel file to another location. The original file name has a date suffix that will change each month so I need to be able to look for a wildcard file name and then copy it. I also want to change the name of the file once it has been copied to the new location.
I have been following the instructions found here:
I am using an asterisk to wildcard the file name in the Source File field and have given it a new name to assign to the file in the "Copy name" section.
The copy activity works fine, however the problem Im having is that it retains the original file name....it wont rename it to the new name.
There is no other file in the source folder.