I have a requirement for a DTS package to read mail from Exchange and process
any file attachments. We receive data files from various vendors this way
which today must be manually saved to a directory and their DTS load packages
manually started, which is slow and error-prone.

Any comments?

Michael

Not natively.

I would look to build a custom task to do this and invoke, if you must,
through DTS.

Allan

"Snake" <Snake (AT) discussions (DOT) microsoft.com> wrote

Hi Snake,

"Snake" wrote:
in addition to Allans idea, you could use the normal SQL Mail feature
inside the dts package with sql tasks.
When you fetch mails with xp_readmail, the attachements should be stored in
an temp folder automaticly, and the pathes are returned in one parameter.
You then have to pass this parameter to an ActiveX task where you strip
this parameter, change the input connections and maybee also loop through
multiple attachements.

Before doing this, you should read the SQL Mail docu and the corresponding
KB articles carefuly, because there are some pitfalls.

Helge