It looks i have a weird Problem. I am attaching a file name xxx.csv in the notification email stage. Job will send the notification along with attachment xxx.csv.
In the sequential file stage, my formatting is 'quote=double" "delimiter=comma".
When i open the xxx.csv on unix, i can see a field data as "8-10". But when i check the xxx.csv in attachement i see 10-Aug. Whats happeining is varchar is being converted to data in the attachment. how can i solve this. Please reply.
Right, that's what it does and there isn't a good way to stop it. Open the attachment in something like Notepad to see the 'real' source data. Change the extension if you want to prevent the file from being automatically associated with Excel.
-craig
"You can never have too many knives" -- Logan Nine Fingers
You can certainly do that, as long as you don't mind the extra characters in the data and you keep in mind the fact that the moment someone 'fixes' them it will revert back to the date it thinks it is.
-craig
"You can never have too many knives" -- Logan Nine Fingers
