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 |
|
Dan18088
Starting Member
2 Posts |
 Posted - 2002-10-01 : 05:53:13
|
| I have created a web app at my company for our call center to update employee data (title, phone#, cell#, ect) and I would like to export this SQL2000 table to Exchange2000. Does anyone know the DTS properties for the connection? It asks for a data source and a login to the server. I have tried every path I can think of as well as different logins but can't connect. Any help would be appreciated!Thanks,Dan |
|
|
ashok
Yak Posting Veteran
57 Posts |
Posted - 2002-10-01 : 09:09:09
|
quote:
Does anyone know the DTS properties for the connection? It asks for a data source and a login to the server.
You could possibly use the 'ExOleDB' OleDB provider to access exchange 2000 folders, you will probably need to use a WebDAV query subsequently to update the exchange folder.try searching on msdn for 'ExOledb and WebDAV' |
 |
|
|
Dan18088
Starting Member
2 Posts |
Posted - 2002-10-03 : 21:53:14
|
| Well after a lot of searching on the NET, I am almost there! I thought I would share this with anyone else that needs or wants to import/export employee data from the Global Address list (GAL). The first thing I found was the data is really stored in Windows Active Directory, not Exchange. So I created a DTS package using the OLE DB provider for Microsoft Directory Services, Data Source is the computer name where active directory is installed, and Location is Schema. Then I added a transformation with this SQL statement:SELECT ADsPath, sn, company, givenName, telephoneNumber FROM 'LDAP://CN=users, DC=Domain, DC=com' All I need now is the rest of the field names to add to my select statement!!!Hope this helps others,Dan |
|
|
|
|
|
|
|
|
DTS export to Exchange 2000 questions