Connect the Source to using the active directory provider and set the details to the LDAP Path:
By default we parse out the Manager field so that it's more suitable for input to SharePoint or something. However you can now switch off this parsing to get to the raw AD attribute value.To update the manager you need to supply the full Distinguished name value of the AD Object you want to set which would be something like this below. CN=Sean Cleaver,CN=Users,DC=xxx,DC=xxx,DC=com Disable the TryParseValue and ReadOnly properties of the Manager field in the Property Collection on the AD Provider.
Here I created a Dynamic Column to return the Distinguished Name of the Manager to set against the AD Users. Alternatively, you could use any attributes returned from the AD fields to set the manager's name.
Now we just create a simple Schema Map mapping the X_Manager to Manager and using DSID as the Key column.
Now we just need to compare the data and synchronise the changes.