SSIS Rename a file with Actual Name + date

Closed - This job posting has been filled and work has been completed.

Job Description

Hi,
I have a package that move .txt files from source to destination.

I would like to rename the file
For example
In Source Folder : the files name are

abc.txt
aroc.txt

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

Thanks

Open Attachment

Other open jobs by this client