.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

SSIS SharePoint List Adapter - how to query Users & Groups?

Posted By:      Posted Date: October 05, 2010    Points: 0   Category :Sql Server

I am using SSIS SharePoint List Adapter to load data in and out of my SharePoint Lists from within SSIS, and most of it is working fine.  However, I need to perform a lookup against the Users & Groups collection in SharePoint so I can retrieve the UserID and set the value when writing back to SharePoint.  Any help would be tremendously appreciated!


View Complete Post

More Related Resource Links

How to join two sharepoint list in c# by CAML query?

Hii All,
   I am using wss 3.0 and i have one site and site has 4 to 5 lists. lists are interconnected with lookup column and same column. I need to display some column fron one list and some from another.. i need to join that lists by where condition like project =project..

So how can i join??

Thank You

using SharePoint List for SSIS package

I need to use a sharepoint list as data source for SSIS package, it works fine until the sharepoint site implement Kerberos only (IIS 7) authentication, anyone knows how to get around this? thanks.

Anyone got the SharePoint List Adapter working with SQL 2005?

Like the authors of some other similar posts, I cannot see the SharePoint list dataflow source and destination options after installing SharePointListAdaptersSetupForSqlServer2005.msi from codeplex.  The options do not appear in the SSIS Data Flow items tab within the "Choose Toolbox Items".  Anyone manage to figure this out? If i install it on my dev laptop - I get these options and can add them to my toolbox - however I have both SQL Server 2005 and 2008 on this machine.   On my 64 bit server however I only have SQL 2005 and nothing! I would love to use this as the last time i wrote a web service extraction is was a very unpleasant few days of my life. Ritchie

Cross list query for two sharepoint lists and a join between the fields

Hello All, I have a requirement where i need to query the data from two  sharepoint lists  on a same site by doing a join between those lists and get the result into datatable.I am doing this using sharepoint object model.Is there any possibility to do this. Any pointers in the right direction are greatly appreciated. Thank you Smith   smith

C# newbie stuck - trying to access column data in a SharePoint list in an SSIS script task

Hello, I'm sure this is the simplest question but I can't figure it out, even with Google's help. I am trying to stumble through some C# code in an SSIS script task and I am frustrated that I can't figure out how to do the easiest things.  I eventually want to find data in a column,and then use another list as a lookup to replace that value with another where the existing value matches a value in the lookup list.  So, the data in my (multiple choice) column might be "apples; bananas" and in another list I have a row that contains two columns, the first holding the value "Apples" and the second containing "Red Delicious" and my original column should read: "Red Delicious; bananas." But, alas, I can't even figure out how to see the data that is in a column. Here is my code: /*<br/> Microsoft SQL Server Integration Services Script Task<br/> Write scripts using Microsoft Visual C# 2008.<br/> The ScriptMain is the entry point class of the script.<br/> */<br/> <br/> using System;<br/> using System.Data;<br/> using Microsoft.SharePoint;<br/> using Microsoft.SqlServer.Dts.Runtime;<br/> using System.Windows.Forms;<br/> using Microsoft.SharePoint.Utilities;<br/> <br/> namespace ST_08becda4c05c49cd9f30ea76110076cd.csproj<br/> {<br/> [

Query Sharepoint list, rich text columns returning HTML tags

Hi! So I have an issue that maybe someone of you have encountered as well. I am querying a Sharepoint list and creating a report from the data collected from this list. This all works fine except that one of the columns in this list is of the type "Multiple lines of text" and also supports "rich text" with different fonts, sizes and so on. This has the effect that the text returned from this column is wrapped in HTML tags that specifies how the text should be formatted. Naturally I do not want this HTML code to appear in my report so for now I have used custom code to do a string.replace and replaced for example <div></div> and <br> with "". However, this column also has url references to documents and these links shows up like this "/servername/site/subsite/Gemensamma%20dokument/Mwh.docx">http://servername/site/subsite/Gemensamma%20dokument/Mwh.docx There is some sort of double reference to the document that I guess like the HTML tags are embedded in the answer from the rich text column and this is not so easy to do a string replace on because the url varies with the different document and document names. My question really is if anyone of you have done a similar report that I am doing, and have encountered this fenomen with this sharepoint column and how you did to solve this? I have tried to creat

Maintain users and groups list of Active Directory for an asp.net web application only

Hi, I have configured active directory in my server 2008. We have a web project using asp.net mvc named Audit planning and Execution Software(Apex2).What we want to do is to authenticate Active directory users for this project.I can get all active directory users, groups, users of a group etc.I want to add users in active directory for the Apex2 project only using asp.net.I also want to display only the users and groups of Active Directory registered with the Apex2 project only. And I also want to add active directory users from whole AD list to our project's AD list. Can you please tell me, how will I do this. Shall I create an Organizational Unit and maintain all users and groups there for our project? Or, is there any other way to do this?  please help me.Thank You

SharePoint List Query Filter


I am writting an SSRS report where I am querying a SharePoint list and trying to filter the data through the CAML query.  In BIDS, the query returns data, but the filter where clause doesn't seem to be getting recognized as I get all of the data back.  The where clause does seems to work in the U2U CAML Query Builder tool.

Can anyone please give advice as to why my where clause isn't working?


   <Method Namespace="http://schemas.microsoft.com/sharepoint/soap/" Name="GetListItems">
         <Parameter Name="listName">
                   <DefaultValue>Subscribe - Sales by Product Group - Wheel</DefaultValue>

display sharepoint list Data into content Query Web Part


Hi i have content query web part. now i want to show the sharepoint list data into my content query part

using CQWP setting, i am able to get only one column data but not all.

pls let me know how can i get all list data in different style format 

Field shows as when using SSIS and sharepoint adapter


Hello, I am setting up an SSIS usingthe Sharepoint Source adapter. I am replacing and existing process that imports data from Sharepoint into Excel directly, but this is manual.  The sharepoint source adapter seems to truncate column names or provides different column names then what is visible on the user Sharepoin site - they all do not match my manual import into Excel and there are additional fields.  I'd assume that what it is returning is the actual Sharepoint Database column name.  Anyway, I need to map my fields to my existing process in SQL.  The only way I know how to do this and identify what columns are being returned, I am attempting to import the data into Excel using SSIS through the Excel Destination.  I'm having an issue with a few fileds....I have a field/column called QAReviews which is importing into Excel with all the fields for each record showing <Lon Text> instead of the value the Sharepoint site actually contains.  In my manual Excel import process, this field shows the correct data.  By the way, on sharepoint this is a choice field. Can someone tell me why I'm getting something different through SSIS then what I get from using the manual import in Excel.  I also exported the data from Sharepoint to Access and again I get the correct data. Please advise.



sharepoint List data not showing in content query web part


hi friends,

i am displaying data from sharepoint list into content query web part.

i have also mentioned column name in commonfield properties after exporting web part and save it.

but it is showing only two column name.

i have also inserted images url in sharepoint list, but i am not able to see images in CQWP.


<xsl:template name="News" match="Row[@Style='News']" mode="itemstyle">
  <xsl:param name="CurPos" />
  <xsl:param name="LastRow" />
  <xsl:variable name="SafeLinkUrl">
    <xsl:call-template name="OuterTemplate.GetSafeLink">
      <xsl:with-param name="images" select="'@images'"/>
  <xsl:variable name="SafeImageUrl">
    <xsl:call-template name="OuterTemplate.GetSafeStaticUrl">
      <xsl:with-param name="images" select="'@images'"/>

Assign sharepoint workflow task to multiple users/groups




I need to assign workflow task to multiple users or groups based on the user department in the active directory. I am trying to use the AssignedTo property of the SPWorkflowTaskProperty to achieve this but don't know how. I tried to put multiple user ids in the sting separated by ";", but this is not working.


Any suggestions are appreciated.

accessing sharepoint sitecollection groups, users, roles and displaying them in sqldatabase



I am working on sharepoint groups, users, roles and permissions. my task is to display all groups,users,roles and permissions from a sharepoint sitecollection in sqldatabase table.the table for groups contains following columns ID,Name,Description,OwnerID,Ownerisuser. the table for users contains following columns ID,Name,Sid,LoginName,Email,Isstieadmin,isdomaingroup. the table for roles and permissions is ID,Name,Description,Type,BasePermission. can someone please help with the code. i have started in the following way using a windows application

private void button1_Click(object sender, EventArgs e)
            using (SPSite osite = new SPSite("http://servername//"))
                using (SPWeb oweb = osite.OpenWeb())

Adding distribution list to the SharePoint groups



I have added some AD groups to the SharePoint Groups i.e. i have added them in the site members group but when the users that are present in the AD group are not able to access the site they are getting access denied error

Please help me on this

Thanks in advance


Sarath Sannadi Sharepoint Dev at Saksoft

SOAP Error 500 when query in Sql Server 2008 using for reporting a Sharepoint list 2007


I'm doing the reporting services for a SharePoint list, the datasource is configured as a connection with http://<Servername>/_vti_bin/lists.asmx and I add the parameters listName , rowLimit and viewName with the

How to update Sharepoint List associated to a workflow with SSIS ?


Hi all,

I've started a new SSIS project which needs to sync daily a SharePoint list into a SQL 2008 database.

Every day the SP list is updated with new suppliers. It is associated to a validation workflow in order to get a clean list.

My SSIS project is looking good so far, when I run it I'm able to get approved records from the SP list into my SQL table.

But I need to go further. I need to tell to the SP list that the datatset I have at the end of my SSIS flow has been synced.

I need to do that in order to have these records only once otherwise at the next run I'll get duplicates.

So my idea was to go for a boolean field in the SP list and update this field and the end of my data flow.

I'm deriving the colum in order to update that in my flow. I set all the records to IsSync == True

But when I run the flow and I check the SP List...only the version field in the SP list has changed and nothing else!

Any help would be appreciated !



Update a Sharepoint List in SSIS (Web Service)?


Good day,

I'm trying to update a Sharepoint List withh SSIS (Web Service)?
I tried using Web Services with vbscript/javascript but struggled for days.

I'm working on a Remote sever diff to the Sharepoint & SQL server (3 diff serv)

But thought if i could get a package to update the list (Sharepoint document library) and then execute the package using vbscipt/javascript through a command prompt.

Firstly i would like to get the package to work before i try & execute the package remotely.

Where can i also find the ssis sharepoint list adapters installer package to install.

Please Assist!

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend