SQLServerCentral.com / Discuss content posted by Joshua Perry / Article Discussions by Author / Article Discussions / Extract more than 1000 active directory accounts / Latest PostsInstantForum.NET v99.99.99SQLServerCentral.comhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 09 Dec 2016 08:31:38 GMT20RE: Extract more than 1000 active directory accountshttp://www.sqlservercentral.com/Forums/Topic401631-492-1.aspxThanks for the script.Thu, 12 May 2016 06:37:09 GMTIwas BornreadyRE: Extract more than 1000 active directory accountshttp://www.sqlservercentral.com/Forums/Topic401631-492-1.aspxThis 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?Mon, 14 Sep 2009 07:15:44 GMTlgibbonsRE: Extract more than 1000 active directory accountshttp://www.sqlservercentral.com/Forums/Topic401631-492-1.aspx[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.Tue, 25 Aug 2009 09:15:33 GMTJoshua M PerryRE: Extract more than 1000 active directory accountshttp://www.sqlservercentral.com/Forums/Topic401631-492-1.aspxtry this....http://www.netapp.com/library/tr/3431.pdfWed, 24 Oct 2007 05:59:54 GMTVaiydeyanathanVSRE: Extract more than 1000 active directory accountshttp://www.sqlservercentral.com/Forums/Topic401631-492-1.aspxPlease 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?Wed, 24 Oct 2007 05:52:51 GMTBridget Elise NelsonExtract more than 1000 active directory accountshttp://www.sqlservercentral.com/Forums/Topic401631-492-1.aspxComments posted to this topic are about the item [B]<A HREF="/scripts/Maintenance+and+Management/31972/">Extract more than 1000 active directory accounts</A>[/B]Sun, 23 Sep 2007 10:59:24 GMTJoshua Perry