SSIS Integration Toolkit for Directory Services by KingswaySoft is an extension for Microsoft SQL Server Integration Services (SSIS) that enables integration with directory service environments such as Active Directory and other LDAP-compliant systems. The toolkit provides specialized connection managers and SSIS data flow components to extract, manage, and synchronize directory objects including users, groups, and organizational units. It allows both read and write operations within directory structures. The solution integrates into the SSIS design environment (Visual Studio / SSDT) and supports execution on on-premises SQL Server Integration Services as well as Azure-SSIS Integration Runtime. It is designed for organizations that require structured automation of identity data synchronization, directory migration, or centralized identity data integration. The toolkit supports scenarios such as synchronizing HR systems with Active Directory, managing group memberships, or consolidating directory information for reporting and compliance purposes.

Key Features

Directory Services Connection Manager Provides authenticated connectivity to directory environments.

• Support for LDAP and Active Directory
• Configurable authentication methods
• Secure credential handling

Directory Source Component Extracts data from directory services.

• Retrieve users, groups, and organizational units
• LDAP query support
• Attribute-level data selection

Directory Destination Component Writes and updates directory objects.

• Create, update, and delete objects
• Manage group memberships
• Modify object attributes

LDAP Query Support Enables flexible filtering and selection of directory data.

• Custom LDAP filters
• Selective attribute retrieval
• Structured result handling

Object and Attribute Management Supports structured identity data handling.

• Manage user properties
• Maintain group relationships
• Handle organizational structures

Error Handling and Logging Provides controlled ETL execution.

• Detailed error outputs
• Row-level error redirection
• Execution logging support

Deployment Compatibility Supports various SSIS environments.

• SQL Server Integration Services
• Azure-SSIS Integration Runtime
• 32-bit and 64-bit runtime support

Benefits

Automated Identity Data Synchronization Enables consistent directory data management.

• Scheduled synchronization processes
• Reduced manual administrative effort
• Integration with HR and business systems

Centralized Directory Integration Facilitates consolidation of identity data.

• Integration with databases and data warehouses
• Reporting and compliance support
• Cross-system user management

Reduced Custom Scripting Minimizes need for custom LDAP or PowerShell scripts.

• Pre-built SSIS components
• Visual configuration interface
• Standardized ETL workflows

Improved Data Accuracy Supports validation and structured updates.

• Controlled attribute mapping
• Error handling mechanisms
• Managed object lifecycle updates

Flexible Deployment Options Supports multiple infrastructure models.

• On-premises SSIS
• Azure-based SSIS runtime
• Hybrid integration scenarios