Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-11-16 : 09:43:16
|
| John writes "Got a rather annoying situation. Clients make updates to their profiles in a system I can't touch. The changes they make are sent to us in an email message. Lots of email messages (100+ megs worth a month). I'd like to get these dumped into a SQL database using SQL mail. How do I (or can I) get xp_readmail to either read or parse messages between 16-30K in size?" |
|
|
RocketScientist
Official SQLTeam Chef
85 Posts |
Posted - 2001-11-28 : 17:23:44
|
| I'd suggest using an outside program to receive the email and parse it, then use BCP or DTS (nah, just use BCP) to pick the data up. xp_readmail isn't built for that much load (arguably, it's not built for load period).If the email is being sent via Exchange, see if you can get POP3 access to the Exchange server, and use a POP3 client to save all the email out. That will be a fairly complicated solution, but trying to use xp_readmail isn't going to be a lot of fun either.-rs |
 |
|
|
|
|
|
Help reading big messages with SQLMail