SQLServerCentral / Discuss content posted by Joshua Perry / Article Discussions / Article Discussions by Author / Extract more than 1000 active directory accounts / Latest Posts

RE: Extract more than 1000 active directory accounts

lgibbons — Mon, 14 Sep 2009 07:15:44 GMT

This would be great to run in a SSIS project. Could you elaborate a bit on how to make it work in SSIS? Do you just paste the code into a script task and change the server and authentication piece or do you need to setup the connections and past a piece of the code in a script task?

RE: Extract more than 1000 active directory accounts

Joshua M Perry — Tue, 25 Aug 2009 09:15:33 GMT

[quote][b]Bridget Elise Nelson (10/24/2007)[/b][hr]Please provide more directions on this. Such as 'LDAP://SERVERNAME/ou=OUName,dc=host,dc=domain,dc=tld'?Can this be ran on SQL server only?[/quote]'LDAP://SERVERNAME/ou=OUName,dc=host,dc=domain,dc=tld' is the way that you specify the Active Directory server, it is called a distinguished name.[url]http://msdn.microsoft.com/en-us/library/aa366101(VS.85).aspx[/url]You can run it completely in SQL server if you use a script task in SSIS to execute the vbscript portion.

RE: Extract more than 1000 active directory accounts

VSVaidya — Wed, 24 Oct 2007 05:59:54 GMT

try this....http://www.netapp.com/library/tr/3431.pdf

RE: Extract more than 1000 active directory accounts

Bridget Elise Nelson — Wed, 24 Oct 2007 05:52:51 GMT

Please provide more directions on this. Such as 'LDAP://SERVERNAME/ou=OUName,dc=host,dc=domain,dc=tld'?Can this be ran on SQL server only?

Extract more than 1000 active directory accounts

Joshua Perry — Sun, 23 Sep 2007 10:59:24 GMT

Comments posted to this topic are about the item [B]Extract more than 1000 active directory accounts[/B]