Need help with Date variables please!

[srjosyula]

Hey!
my outfile name is flatfile_report.txt
How can I get the current date in from of the report name everytime it is generated?
Like in Unix we do
${CURR_DT}flat_file_report.txt

it gives
20061012flatfile_report.txt


Anything we can do in informatica at the session or mapping level?

Thanks in advance

 

[blom0344]

No, you need to run a command task that renames the outputfile directly after the original session completes.

Something like :

%DATE%flatfile_report.txt

like:

rename [Drive:][Path] flatfile_report.txt %date%flatfile_report.txt

Ties Blom