Help Index for Active Directory

Documentation on the SSIS Active Directory Components

Integration Components for Active Directory

The Active Directory components are included within the SSIS Integration Toolkit for Directory Services. These components facilitate integration with Active Directory.

You can use these components for integration or migration with any of the following:

  • Establish connections with Microsoft Active Directory and Microsoft Azure Active Directory.
  • Read user, group, and computer record data with support of custom fields.
  • Supports the use of Search Criteria to filter data in LDAP filtering format.

There are 4 components available for use when working with Active Directory data:

  • Active Directory Connection Manager
    • Facilitates the connection to Microsoft Active Directory and Microsoft Azure Active Directory.
  • Active Directory Source Component
    • Facilitates reading / retrieving data from Microsoft Azure Active Directory and Microsoft Active Directory.
  • Active Directory Destination Component
    • Facilitates writing data to Microsoft Azure Active Directory and Microsoft Active Directory.
    • Five different write actions for writing to the server: Create, Update, Upsert (since v2.0, On-Premises only), Upsert (since v2.0, On-Premises only), and Delete objects.
    • Send date time values to Azure Active Directory in UTC format.
    • Map unmapped Active Directory attributes by matching their names with the input columns from upstream components. Additionally, map the columns from upstream components to destination attributes and reset all your mappings in the destination component.
    • Enable dynamic update of the property at run time.
    • The Generate Documentation icon creates a Word document which describes the component's metadata including relevant mapping, and so on.
    • Write data to custom attributes in Active Directory.
    • Specify how errors should be handled when they occur.
    • Create membership between users and groups that reside in different container paths.
  • Azure Active Directory Token Manager
    • Allows you to add, remove, import, and export your Azure Active Directory Tokens from machine to machine.

Video Resources

Youtube Video - Getting started with the SSIS Integration Toolkit for Directory Services