How to append a time stamp to the ouput file in FTPStage ?

laxmi_etl · Post by **laxmi_etl** » Tue Nov 28, 2006 5:14 pm

Hi-

How to append a timestamp to the ouput file in FTPStage ?

Thanks

ray.wurlod · Post by **ray.wurlod** » Tue Nov 28, 2006 5:16 pm

Job parameter containing the full file name?

laxmi_etl · Post by **laxmi_etl** » Tue Nov 28, 2006 5:21 pm

Yes. the file name is parameterized.

narasimha · Post by **narasimha** » Tue Nov 28, 2006 6:47 pm

Does appending #DSJobStartTimestamp# to the outputfile not help?

chulett · Post by **chulett** » Tue Nov 28, 2006 7:55 pm

Or pass in the timestamp as a job parameter and concatenate the two pieces in the FTP stage.

laxmi_etl · Post by **laxmi_etl** » Tue Nov 28, 2006 9:37 pm

How do I pass the timestamp in job parameter??

chulett · Post by **chulett** » Tue Nov 28, 2006 9:49 pm

Not sure what else to say other than you generate it and pass it into the job as a parameter. The 'old fashioned' way would be to create a routine that gets a system timestamp and strips out all the yucky bits you don't want, typically the dashes and colons.

From '2006-11-28 20:44:13' to '20061128_204413' perhaps?

Sequencer job runs it and passes it to the FTP job. Heck, for all I know you can do this all directly in the Job Activity's parameter value nowadays, haven't tried.

nvuradi · Post by **nvuradi** » Wed Aug 29, 2007 4:48 am

narasimha wrote:Does appending #DSJobStartTimestamp# to the outputfile not help?

Hi tried appending the #DSJobStartTimestamp# with the file name but the job is aborting with following error message

test_2007-08-29 05:49:57.txt is not a valid path name

is der any other way to append the timestamp to file without using job parameter and after job routine?? any idea??

Thanks
Narendar :

mohdsuf · Post by **mohdsuf** » Wed Aug 29, 2007 5:16 am

I have a ready shell script script which can be used to append timestamp to the file name.
Just tell me the excat format which you want your output file to be. May be that shell script helps you out and it can be called from after job subroutine.

nvuradi · Post by **nvuradi** » Wed Aug 29, 2007 5:25 am

mohdsuf wrote:I have a ready shell script script which can be used to append timestamp to the file name.
Just tell me the excat format which you want your output file to be. May be that shell script helps you out and it can be called from after job subroutine.

i have the script with me which i can use but i wanted to do this within a job without using job parameter and after job routine and also script.

ray.wurlod · Post by **ray.wurlod** » Wed Aug 29, 2007 4:28 pm

Can't be done. Go with the parameter.