I have been trying to use SPSite to get a list of user profiles in an SSIS Source script component using code from the MSDN site.
When I run the code (see below) I get this set of errors.
at Microsoft.SharePoint.CoreResource.GetString(ResourceGroup rg, String name, Object[] values)
at Microsoft.SharePoint.SPResource.GetString(String name, Object[] values)
at Microsoft.SharePoint.SPSite..ctor(SPFarm farm, Uri requestUri, Boolean contextSite, SPUserToken userToken)
at Microsoft.SharePoint.SPSite..ctor(String requestUrl)
at ScriptMain.CreateNewOutputRows()
at UserComponent.PrimeOutput(Int32 Outputs, Int32[] OutputIDs, PipelineBuffer[] Buffers)
at Microsoft.SqlServer.Dts.Pipeline.ScriptComponentHost.PrimeOutput(Int32 outputs, Int32[] outputIDs, PipelineBuffer[] buffers)
Any help gratefully accepted
public override void CreateNewOutputRows()
{
/*
Add rows by calling the AddRow method on the member variable named "<Output Name>Buffer".
For example, call MyOutputBuffer.AddRow() if your output was named "MyOutput".
*/
using (SPSite site = new SPSite("http://sp-dev/default.aspx"))
{
ServerContext context = ServerContext.GetContext(site);
UserProfileManager m_mngr = new UserProfileManager(context);
// Get the properties
Microsoft.Office.Server.UserProfiles.PropertyCollection props = m_mngr.Properties;
foreach (Property prop in props)
{
Output0Buffer.AddRow();
Output0Buffer.UsersName = prop.Name.ToString();
//Output0Buffer.UsersName = "test";
}
}
} 

