Skip navigation
Contact Us
3093 Views 10 Replies Latest reply: Jan 20, 2014 2:47 AM by Kiran Ghatage RSS
lavan kumar Apprentice 169 posts since
Apr 13, 2011
Currently Being Moderated

Dec 14, 2012 4:37 AM

How to append date stamp to a target flat file name ..?

Hi All,

 

Please help me any one I am trying with the below menthod but i am not able to achieve

 

1) created a  File Name Port in the Target Instance

2) In Expression Transformation Created a New Output port with string Datatype and Given

O_FILENAME   O/P    exp: 'TARGET_FILE_NAME'||to_char(sessstarttime, 'MM/DD/YYYY')||'.txt' Connected to The Target File Name Port

3) In the Session properties Output File =Dummy.txt

 

'TARGET_FILE_NAME'||to_char(sessstarttime, 'MM/DD/YYYY')||'.txt'

 

 

But Getting the error Like

WRT-8004 Writer Initialization Failed

[error openeing session output file

[error=the system cannot find the path specified]

 

But the output data file is coming with the name which is given in the Session properties as Dummy.txt

 

 

Thanks,

Lavan

More Like This

  • Retrieving data ...

Bookmarked By (0)