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.