I am trying to write a ssis package which moves clients file from certain directory to another.
Source Path : D:\Temp\Source\Client A_CSV
D:\Temp\Source\Client B_CSV etc
Source Directory has many folders of clients like Client A_CSV etc.
I want that when i move files to ARCHIVE directory,so that it rename the files with time stamp.
So far, i have been able to move with file task, but it does not allow me to rename file as I retrieve
FULLY QUALIFIED PATH as loop enumerates,
So,,any idea ,, how i accomplish renaming with file system task or Script Task,