When I'm querying the object Security Principal while using LDAP Source, how can I return the sAMAccountName?

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+.