Groups | Blog | Home
all groups > sql server dts > may 2005 >

sql server dts : Can a DTS Package receive mail and access Attached Files?


Snake
5/31/2005 4:09:14 PM
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?

Allan Mitchell
6/1/2005 12:00:00 AM
Not natively.

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

Allan

[quoted text, click to view]
Helge C. Rutz
6/1/2005 12:00:00 AM
Hi Snake,

[quoted text, click to view]

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
AddThis Social Bookmark Button