ssis - rename files in a folder

[spb327]

Hi ,

 

I have folder with files but the data is different in each file. How to rename the file with an sql query, the query holds the name of the files that should be renamed to like (Firstname_lastname.pdf)

 

 

Thank you

Edited March 1, 2021 by spb327