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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-12-22 : 08:24:53
|
| Chuck writes "Windows 2003SQL 2000sp3aI am tasked with querying Active Directory and placing results in a SQL table. I have tried the examples using link server (ADSI) but that is limiting to 1000 records...need more. We have over 13k accounts.So the thoughts are to query AD with ADO and place the results in table using DTS package.I am looking to get the information of user's from the root level and all sub OU's.Information like name, primary smtp address, phone number.Thanks for any help or guidance.Chuck" |
|
|
ehorn
Master Smack Fu Yak Hacker
1632 Posts |
Posted - 2003-12-22 : 10:36:24
|
| The following link may provide some help:http://www.freevbcode.com/ShowCode.Asp?ID=710 |
 |
|
|
|
|
|
Query AD and place results in a SQL table via a DTS packge