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
Karen

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

"Karen Middleton" <karenmiddleol (AT) yahoo (DOT) com> wrote