Page 1 of 1

Extracting attachment from email

Posted: Mon May 16, 2011 8:04 am
by major
Hi all,

I have a requirement where users will send data as an attachment in csv format.
Everytime I save the attachment in predefined folder and trigger the datastage job.
Now a days I am getting more than 50+ requests like that.

I would like to automate the process using datastage. Is there any way in datastage where we can read the attachment from email and trigger the job.

Any better ideas are welcomed.

Thanks in advancemajor

Posted: Wed May 18, 2011 7:31 am
by major
Hi Guys,

Any help or suggestions.

Thanks
Major

Posted: Wed May 18, 2011 8:45 am
by DSguru2B
Instead of continuing to accept requests via email, create a shared folder, ask folks to drop off the files there, create an ftp script to get the data onto your server and then run your process.