Thanks for your feedback.
The request became a bit more challenging.
1 - I need to obtain from a database the paths for the files that I need to copy (No problem). The files are stored in multiple subfolders.
2 - The files need to be renamed and then copied to their final location.
I think I'll use a .Net script to achieve this. I was hoping to use WinSCP but this might be just too much for it.
Either create the file list with
Or use the file list to generate ad-hoc upload script.