How to get a DTS package run to be triggered by a email -- sql server dts

karenmiddleol NO[at]SPAM yahoo.com
3/18/2005 9:27:03 AM

I have a scenario where the data to be loaded into SQL comes in a
email.
The business is asking me to build a package that will enable the
email to trigger a DTS package which must be able to take the
attachment coming as part of the email and process the file.

Kindly advice how this can be done.

Thanks

Francesco Anti
3/18/2005 6:53:22 PM

If you use Ms Outlook you can define a rule that monitor the inbox folder
and calls some VBA code (see http://www.outlookcode.com/d/code/zaphtml.htm
for an example ) that saves the attachment in a definite folder and then
calls your DTS via DTSRUN.
Or you can write a program if you don't want to use an oulook rule and
DTSRUN.

Francesco Anti

[quoted text, click to view]

sql server dts : How to get a DTS package run to be triggered by a email