Hi SoHelpMeCodd,
Thank you for your help, its working for me,
i have one more problem in Header of the output file,
when i open output file in excel the header is displaying as expected HDR but the date and time are displayed within quotes "YYYYMMDD" , "HHMMSS"
actual out put from csv should be
HDR YYYYMMDD HHMMSS
and when it is opened within notepad++ it should be
"HDR", "YYYYMMDD", "HHMMSS"
is there any setting that i need to configure in properties of DFT, i am using expression in DFT properties to get header.
Thanks in advance