Using the LDAP Source Component

The LDAP Source Component is an SSIS data flow pipeline component that can be used to read / retrieve data from LDAP.

The component includes the following two pages to configure how you want to read data from LDAP.

  • General
  • Columns

General page

The General page of the LDAP Source Component allows you to specify the general settings of the component. 

LDAP Source Component - General

Select the connection manager and source object

Connection Manager

The LDAP source component requires a working connection in order to connect with LDAP. The Connection Manager drop-down will show a list of all LDAP connection managers that have been created in the current SSIS package or project.

Source Object

Based on the user permissions, the Source Object drop-down lists all of the currently supported objects which you can read from.

LDAP Settings

Container Path

The Container Path option lets you specify the Directory path that you want to narrow your search scope to. You can click on the ellipsis button (…) to choose the path.

Search Criteria

You may use the Search Criteria to filter particular records according to your requirements. The LDAP Search Criteria filter follows the Lighweight Directory Access Protocol (LDAP) filtering format.

  • All expressions should contain parentheses. Ex. (objectCategory=person)
  • You may use relational operators to form your expressions (ex. '<', '<=', '=', '>=', '>')
  • You may use compound expressions within your filtering such as '&' and '|'

For more information, you may refer to the Search Filter Syntax  page.

Expression fx Icon

Click the blue fx icon to launch SSIS Expression Editor to enable dynamic update of the property at run time.

Generate Documentation Icon

Click the Generate Documentation icon to generate a Word document which describes the component's metadata including relevant mapping, and so on.

Columns page

The Columns page of the LDAP Source Component shows you all available attributes from the object that you specified on the General page.

LDAP Source Component - Columns

It is possible to read data from additional attributes in LDAP. By default, some attributes cannot be detected in the Source component. So there is an 'Add' button, to manually add the additional field. If you select this button, you can add custom fields by entering the following information:

LDAP Source Component - Add custom field

Field Name

Specify the Field Name of the custom field that you would like to read from.

Data Type

Select the Data Type drop down of the field type.

Length

Choose the Length of the Data Type for your custom field.