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.