How to dynamically name a file

mchaves · Post by **mchaves** » Mon Nov 07, 2005 10:12 pm

Hi there,

I need to export data into a file that has to have this sort of name "dailyextract_yyyymmdd". How can I do this using a job?

I know that's something to be informed in the filename in the sequential file stage but I am not sure what.

Cheers

kcbland · Post by **kcbland** » Mon Nov 07, 2005 11:20 pm

Use either a job parameter or a macro.

mchaves · Post by **mchaves** » Mon Nov 07, 2005 11:39 pm

Mate,

I would like to use a macro. Could you post an example using macro?

Cheers

kcbland · Post by **kcbland** » Mon Nov 07, 2005 11:48 pm

Use the Search facility, there's a lot of commentary on how to use one. For a date, check out macro DSJobStartTimestamp.

mchaves · Post by **mchaves** » Mon Nov 07, 2005 11:51 pm

Got it!!!

The file name in the sequential file stage should look like :

#Source_Dir#\DailyBadDebt-#DSJobStartDate#.csv

ray.wurlod · Post by **ray.wurlod** » Tue Nov 08, 2005 5:03 am

Well done! And the work you expended in your research will benefit you by establishing the neuronal paths that help you to retain that knowledge.