When I'm querying the object Security Principal while using LDAP Source, how can I return the sAMAccountName?
If you are not seeing sAMAccountName in the metadata then you should:
1. Open the LDAP Source dialog and go to the 'Input and Output Properties' tab.2. Go to LDAP Source -> External Columns list and add a column 'samaccountname'. Specify the type to be DT_WSTR and length 250.3. Go to LDAP Source -> Output Columns list and add a column 'samaccountname'. Specify the type to be DT_WSTR and length 250.4. Go to 'Column Mappings' tab and map the external -> output samaccountname column.
If the sAMAccountName is still not being seen, then you need to check if the user that you have used in the connection is allowed to retrieve the sAMAccountName.
Book a Presales Call
Are you new to COZYROC and evaluating our solutions?
Book a Presales Call with us now and get 5% off SSIS+.
Book a Presales Call with us now and get 5% off SSIS+.
Related Articles
LDAP Source: How to modify the source object dynamically at runtime
The source object parameter is available in the data flow properties list. Follow these steps to set up an expression: Create a variable that can be loaded with the desired object name. Right-click on the data flow canvas and select ...LDAP Destination attribute sAMAccountName for object Group is not initialized in the metadata
If LDAP Destination column sAMAccountName is missing in the metadata for object Group then you should follow the steps below: 1. Open the LDAP Destination dialog box and go to the 'Input and Output Properties' tab. 2. Go to LDAP Destination -> ...Error message: LDAP Source error: Failed to process {...} for column {Column Name}
Action: When using LDAP Source component I get the following error: Error Message: LDAP Source error: Failed to process {...} for column {Column Name} Solution: Most likely the Output Column is not large enough to accommodate the input text . To ...LDAP Source: How to modify the filter dynamically at runtime
The filter parameter is available in the data flow properties list. Follow these steps to set up an expression: Create a variable that can be loaded with the desired filter. Right-click on the data flow canvas and select the Properties menu. Scroll ...Where can I find the documentation for the LDAP Source?
You can find documentation related to all the COZYROC SSIS+ Component Suite components from the main products page. Specific documentation for the LDAP Source can be found at the following link. For many of the components you can find resources ...