I NEED TO DEVELOP A DTS TO READ SUBJECT FROM ALL MESSAGES FROM A SPECIFIC EXCHANGE INBOX, AND IF POSSIBLE MARK AS READED.

HOW CAN I DO THAT?

THANKS

--
Message posted via http://www.sqlmonster.com

Not really sure DTS is the tool to be doig this but I would probably create a custom task to do it.

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - SQL Server 2005 Integration Services.
www.Konesans.com


"Alfredo Frugone via SQLMonster.com" <forum (AT) SQLMonster (DOT) com> wrote

Thanks for replay,

Curently I've an access aplication, but I depend of the user who is connected to actualize manually the information from his inbox.

We have a very simple application, we deliver goods to our customer, when the client receive the product the driver uses his celular phone and send an e-mail with the invoice number.

So what I want to do is run a DTS the read tis e-mail un update a database

If you have a better idea pleas etell me.

Thanks

--
Message posted via http://www.sqlmonster.com

Could you not then use xp_readmail and its associated family of procs ?

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - SQL Server 2005 Integration Services.
www.Konesans.com


"Alfredo Frugone via SQLMonster.com" <forum (AT) SQLMonster (DOT) com> wrote

OK, I'll try ir

Thanks

--
Message posted via http://www.sqlmonster.com