Hello, I need to load txt file every fri, to the SQL table, as well rename it when load comlete in the directory where file comes from to the current week.

Is there a way to use it in DTS as well is there a way to rename it?

Thank you very much.

File name is ORIWE.txt has to be renamed to (1-7-06orv.txt)