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 - 2003-07-03 : 07:47:59
|
| Rich writes "I have found scant information regarding the importing of emails into DTS. I managed to discover the "Microsoft OLE DB Provider for Outlook Search" but I can't find anything written about how to implement it. Perhaps someone here can help solve my problem?I have an email account setup something like:\\serverbox\exchange\alienbeings\companymailbox_1\inboxOnce every while the company sends an email with an Excel attachment. I want to look at the attachments by name and if they are titled properly I want to pull them into DTS for processing. I have been able to process xls files. All I need to do now is pick the right one from the email inbox and I'm done.My exchange box is not on the same box as sqlserver and we do no runn http service on it.Any assistance either code wise or reference wise is much appreciated. My deadline is July 1..yikes!!!Cheers!!" |
|
|
|
|
|
How do I Import specific emails from Outlook 2000 into SQL Server 2000 DTS for processing