Create Address List from MSSQL Database

howdy all,

i have extensively search web documentation on importing database information address list. no luck.

i have come across bucket loads of information on retrieving ad information in sql, not other way around. trying create new distribution lists (address lists) company stored contacts in our company databases.

i have openquery , regular query retrieves information sql, somehow cannot figure out how use/import results ad (where not have continuly import results once information gets updated quite frequently). tried using custom search in ad allow ldap queries, not prove job in instance (simply put - sql query not ldap query).

tried looking sql ldap conversion no luck. not know how query sql database ad.

any pointing me in right direction appreciated.

p.s. ms sql server 2000, exchange 2003, windows server 2003

cheers,

eldin

eldin,
dts flexible in terms of types of actions can accommodate. might want consider creating script (you can use http://gallery.technet.microsoft.com/scriptcenter/en-us/e3487e49-6e3c-4773-9cab-94434bc4356c as starting point) , implement script task in dts package...

hth
marcin

Windows Server  >  Directory Services