Retrieving Data from Active Directory

Retrieving Information from Active Directory with SSIS

This one show how to use the ADO.NET connection manager to retrieve data from Active Directory. The problem is the SSIS don’t support all ADO properties. There is no way to set the number of returning objects, LDAP_OPT_SIZELIMIT . In most case, the AD will return 1000.

Return All My User Accounts

This one show how to use the VBscript and ADO to retrieve the data from Active Directory. It use the Page Size property to get around the problem. It work well.

Active Directory Users

This one show how to use the C#.Net script and the System.DirectoryServices to retrieve data from Active Directory. It works.

More samples for System.DirectoryServices

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s