title: Pulling useful info from a MOSS 2007 Person or Group Field dumped via SSIS package
body: <p>I’ve got a list defined that, as one of the fields (actually a few of the fields), has a Person or Group picker. I’m extracting the entire list through an SSIS package using the SharePoint List Source data flow source dumping into a SQL table. The PoG picker field dumps its data like so (each line being a single data item):</p>
  
  <pre><code>163;#Jones, Danny S.
  179;#Smith, Sandra M.
  164;#Thomas, Rob Y.
  161;#Ross, Danny L.
  2064;#Smith, Michael D.
  </code></pre>
  
  <p>I would guess that the number preceeding the ;# is some sort of User ID that SharePoint keeps with the user instead of something helpful like an ADS guid. Can I use SSIS to pull SharePoint’s user profiles so I can match the ID shown to an ADS guid or ADS username, and if so, how? I've tried using the Web Service task within SSIS to call the User Profile service (http://www.my.site/_vti_bin/UserProfileService.asmx), but I get an error about the WSDL being a wrong version.</p>