September 20, 2001 at 2:54 pm
Is there anyway to read the Exchange Global List from SQL 7? I'm interested in getting all the Mapi and SMTP email addresses into a database.
September 20, 2001 at 6:27 pm
I'm not familiar with the Exchange Global list. Is it a text file?
If so, might be able to parse the file with the file system object in a vbscript dts task to get at the info you need. A little crude, but it might work.
September 22, 2001 at 11:50 am
Obviously the trick is getting the data out of Exchange. If you're running Win2K, here is one possibility:
http://support.microsoft.com/support/kb/articles/Q241/4/74.ASP
This shows how to export them:
http://support.microsoft.com/directory/article.asp?ID=KB;EN-US;Q278154
There is also an OLEDB provider (have not tried it), but this might work out pretty well:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/acdata/ac_8_qd_12_0t5x.asp
I'd suggest browing MSDN some more or trying one of the Exchange sites if these don't help.
Andy
September 23, 2001 at 11:44 am
Thanks Andy,
I've looked at all 3 methods you suggested. My exchange group is concerned about loading the Active Server drivers. Unfortunately The export is rather time consuming with over 17,000 email addresses and 5 email systems connecting into the exchange directory. I just kept hoping someone had run accross a simple way to import the information. I need to get a copy of the Exchange 2000 OLE DB and give this method a try.
September 23, 2001 at 1:43 pm
Could you give some background on what you're going to do with the data?
Andy
September 24, 2001 at 7:34 am
Basically, we have an employee SQL 7 database that feeds numerous other systems. A couple of the fields they want available is both SMTP and Mapi email address updated in real time. An hourly update is acceptable.
Currently, I receive a CVS download from the Exchange 5.5 server. I convert it to Excel and perform a couple macros to clean out the extranious data. Then I execute a DTS package to import the information. Unfortunately, I'm manipulating 17,000 plus records. I'd really like to completely automate the process by having SQL 7 read the Exchange Global directory and update changed records only.
September 24, 2001 at 4:04 pm
Gotcha. I'd really suggest looking for a good exchange web site, maybe get some other ideas. Your current solution doesn't seem bad - does it take long or just not elegant enough? You could tweak a little by replacing the Excel step with some Active scripting in your DTS package. Does your current solution require hands on? Or does it run unattended?
Andy
Viewing 7 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply