SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I get a nightly update of all users' profile properties via csv. I would like to setup the User Profile Service App to sync to that CSV. I assume this shouldn't be terribly difficult and has likely been done before. However my Google-Fu is not up to snuff and I cannot find any good examples. I have found some examples using PowerShell but I thought that using BCS and sync might be a better idea. Could someone please help me find an example of doing this in C#?

share|improve this question
up vote 1 down vote accepted

Personally, I would use PowerShell. But, if you really must use BCS, look at the samples for creating a custom BSC Connector to XML, XLS, or CSV. There are several out there. Scot Hillier wrote the book and there are samples in there:

Once you have the BCS connection working you then create a secondary sync connection in the UPA for your BCS import and identify the key, like email or username.

Note, you will still need an LDAP source for initially creating users.

share|improve this answer
What are the advantages of PowerShell over BCS? – James Grizzle Mar 28 '13 at 16:02
Mostly, IMO, simplicity. Adding BCS adds a layer of complexity that may not be required. You can still schedule the job. – Matthew McDermott Mar 29 '13 at 12:51

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.