Extracting attachment from email

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
major
Premium Member
Premium Member
Posts: 167
Joined: Mon Nov 26, 2007 12:21 am

Extracting attachment from email

Post 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
major
Premium Member
Premium Member
Posts: 167
Joined: Mon Nov 26, 2007 12:21 am

Post by major »

Hi Guys,

Any help or suggestions.

Thanks
Major
DSguru2B
Charter Member
Charter Member
Posts: 6854
Joined: Wed Feb 09, 2005 3:44 pm
Location: Houston, TX

Post 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.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
Post Reply