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
Related Articles
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 ...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 ...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 ...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 ...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 ...