Hi dear VisualCroners,

it's my first forum input - hope you can help.
I have a structure on filesystem like

• ..\generalFolder\Folder1\test1.csv
  ..\generalFolder\Folder2\test2.csv
  ..\generalFolder\Folder3\test3.csv

The targeting sftp server has the same structure.

My idea was, add a "List file(s)" Task at first to write all founded files with their full Path into output as several lines.
Then add a "SFTP-Upload" Task, take line by line with Loop and put the files in one procedure in the correct Folders (Folder1 or Folder2 or Folder3).
The problem i had is that i couldn't trim full path name to the last Foldername (f.e. Folder1) and filename (test1.csv).
The functions in the variables-universum didn't help...

Thanks for help!
Cheers EduardW

We do not have any built in way for creating folder structure on FTP. Theoretically you can do one of 2 solutions:

1. create on Upload command for each target folder (if not to many target folders)
2. Use list files, create upload Task in a loop and some way extract the folder on the full path. But if you just want the parent folder like "Folder2" you need to extract it with .NET or PowerShell Task. But it is a bit unclear which part of file you wanted?

---