SSIS Rename a file with Actual Name + date
Closed - This job posting has been filled and work has been completed.
I have a package that move .txt files from source to destination.
I would like to rename the file
In Source Folder : the files name are
I would like to rename them to
abc03192014:030100PM (means 03/19/2014 at 030100PM)
abc03192014:030115PM (means 03/19/2014 at 030115PM)
The date is the system date.
FileArchive is the destination : I would like to make it variable
InputFileSource is the Source : I would like to make it variable
I would like to add a variable SourceFileType: for example *.txt or *.csv