The easier and preferred method is to simply create a variable for the path and use get date functions. Click the connection manager for the output text file --> View the properites --> expand "Expressions" and modifiy the connection string as follows:

Note: @[User::SharePath] is a variable that holds the path.

@[User::SharePath] +

RIGHT("0" + (DT_STR,4,1252) DatePart("yyyy",getdate()),4)+

Right("0" + (DT_STR,4,1252) DatePart("m",getdate()),2) +

Right("0" + (DT_STR,4,1252) DatePart("d",getdate()),2) + ".txt"

-----------------------------------------------------------------------------------------

Hi, I tested this, this is working fine. do I need to create "File system task" to do this?

basically I want to rename the file.

ex:C:\hello.txt to c:\hello_2009-July-30.txt

I mean filename+todays date.txt

Thank you,

Jyosthna