Hi,

I hope someone can help. I would like an SQL server 2000 dts
task(Transform data task) to be triggered by an email. Based on the
sender and the subject of the email I would like the task to start as
soon as the email is received.

Is this possible?

Thanks in advance

Hi Loic

I believe it's possible, but you need to program an VBA macro in Outlook Professional (97-2003), this resource is only available in professional and developer edition. Just you compose a macro using a DTS Object Model, pass its parameters e call a "execute" method. One more thing, you need all objects of DTS Object Model installed on machine that will shoot the macro.

Thanks Humberto. I'll see if I can do that. I was hoping for something
more simple. Maybe a dts task could be scheduled to look for that
email every 30 mns, and when it finds it, triggers the other task.

Thanks again for your help.


"Humberto" <hsantiago (AT) wa (DOT) com.br> wrote

Loic wrote:
Should be.
Look in SQL Books Online for sp_processmail

regards

frank
www.xax.de