How to get a DTS package run to be triggered by a email - 03-18-2005 , 11:27 AM
I have a scenario where the data to be loaded into SQL comes in a
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.
Re: How to get a DTS package run to be triggered by a email - 03-18-2005 , 11:53 AM
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
"Karen Middleton" <karenmiddleol (AT) yahoo (DOT) com> wrote