TimRochette
Technical User
Our firm has a Windows 2000 environment with Active Directory. Exchange and the mail store are on one server, Active Drectory (our Name server) is on on another mahcine, and we have out SQL server on a separate machine.
I need to get the employee's name and email address out of AD/Exchange and into a SQL table. We do not want a live link, but a scheduled transfer. I was goiong to use the OLE DB Provider for Exchange, but the mail store is not on the same machine. I tried DTS, but did not find the correct driver. I tried linked servers, but I cannot link a non sql server with a sql server.
I am reading thigns all voe rthe internet on how to do it, If someone could point me in the right direction, it would be much appreciated.
Thanks,
Tim Rochette
Database Administrator
S E A Consultants, Inc
I need to get the employee's name and email address out of AD/Exchange and into a SQL table. We do not want a live link, but a scheduled transfer. I was goiong to use the OLE DB Provider for Exchange, but the mail store is not on the same machine. I tried DTS, but did not find the correct driver. I tried linked servers, but I cannot link a non sql server with a sql server.
I am reading thigns all voe rthe internet on how to do it, If someone could point me in the right direction, it would be much appreciated.
Thanks,
Tim Rochette
Database Administrator
S E A Consultants, Inc