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


Top 5 Contributors of the Month
MarieAdela
Imran Ghani
Post New Web Links

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

Posted By:      Posted Date: April 14, 2011    Points: 0   Category :
 

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 !

Regards,

Pierre




View Complete Post


More Related Resource Links

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!


Trying to send email using Sharepoint Designer 2007 workflow and email enabled list

  

I have a a list that recieves email. I have few fields that shows me the originator: "E-Mail From" and "E-Mail Sender".

I am trying to create a workflow that will generate an auto reply to the originator but the SPD fails to recognize the email address in these two fields. It's either truncating part of it or uses the html ( href=mailto:Demo@DemoSomething.com) in the To field.

Thank you,
Tzach.

 


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.

Concurrent update in sharepoint list item

  

Hi,

How the concurrent for sharepoint list item are are handled.

if two or more users are working on same item. Then how sharepoint process multiple update request for particular list item.


Update SharePoint List item using UpdateListItem web service with javascript

  
I'm using the Custom_AddListMenuItems function in a CEWP to add a menu item to each list item to Archive that item. This is achieved by updating a choice field in the item to 'Archived'. I'm trying to do this using the web service UpdateListItem web service to update the item using Javascript, but I can not find the correct code that updates the list item. I'm using this code:     var ctx=currentCtx;     var ciid=currentItemID;     var xmlHttp=null;     if (confirm("Are you sure you want to Archive this item?"))     {         var soapRequest = '<?xml version="1.0" encoding="utf-8"?>'+             '<soap:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">'+             '    <soap:Body>'+             '        <UpdateListItems xmlns="http://schemas.microsoft.com/sharepoint/soap/">'+         

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/> [

How to prevent automatic update from sharepoint list on Infopath 2007 form

  
Hi there, I've got an Infopath 2007 form on MOSS 2007. I have a custom list in sharepoint and the infopath form has a data connection to that list to receive data. Is there any way to prevent automatic update on the values in the form that is received from the list. I'd like the new form to have updated info received from the list. However, the old/existing forms that were created should have the data that were available at the time when the form was created. Let me know if this is not clear and I'll try to explain more. Thanks,Pman http://www.pmansLab.com/

Copy List not Working in Sharepoint 2010 Designer Workflow

  
I am having two custom lists,  First_List(Title, ID, Status) and Second_List(Title, ID) here Status is a choice menu with values Selected and Rejected I am copying data from First_List to Second_List using WorkFlow with SharePoint Designer, When I am inserting data in first list. For that I have written in workflow action if CurrentIten. Status equals Selected  Copy item in current item to Second List now the Problem is that only the Title field is getting copied into the Second List but I am unable to copy the ID field. I am unable to understand whats the problem    

Invalid data has been used to update the list item in sharepoint 2010.

  
I have created a custom list definition with one lookup field <      Field ID="{865CD714-7DF6-4F65-9DBC-5FE910B10BC5}" Name="CompanyName" DisplayName="Company Name" Group="Custom contents" Description="Select Company" Type="Lookup" ShowField="CompanyName" Required="FALSE" FieldRef="CompanyName" List="Lists/LookupListDefinition-ListInstance1" ReadOnly="FALSE"></Field>   <nativehr>0x80070057</nativehr><nativestack></nativestack>Invalid data has been used to update the list item. The field you are trying to update may be read only. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. My solution is perfectly get deployed on site. I can see the list instance created on site its also appears on quicklaunch. When i am trying to add the item into the custom list using UI then i am getting the input form correctly i can see the lookup values in dropdown list but when i click on save button then its give me an error as mention above. For debugging purpose i have created the event reciver class for list item adding event. In that i have check the column status and

SharePoint 2010 email enabled list with workflow has incorrect User ID when items are emailed to the

  
I have set up an approval workflow for a document library that has email enabled. Emails come into the document library fine, however, if an item is emailed to the library the workflow kicks off with the initiator as "System Account" rather than the person who submitted the email. This makes the error of "The e-mail message cannot be sent. Make sure the e-mail has a valid recipient." come up. If someone submits a document directly to the library (by logging into sharepoint and submitting) everything works fine. The person submitting by email is a valid sharepoint user and the profile shows the correct email address. The Created by and Modified by fields show the correct person (rather than System Account), it's only the workflow User ID that shows incorrectly if document is emailed to library. Any help or ideas would be appreciated. Thanks

Cannot update Extenal list from worflow in Sharepoint 2010

  
Hi, I try to update an external list from a step in worflow; I did in Sharpoint Designer. I did that: 1. I create a List and put one field from my external list 2. In the action I chose: Update list item 3. In the drop down list I chose: External List 4. In the find the list Item: I look for my ID in my external list and past this value for current Item. 5. I published this workflow 6. I ran this workflow in my list But when I running in my list and finish: This workflow don't upated my external list and write in the log: Error.  :( What can I do. The user have permision in my list and in my external list too for write and read (full control),

Update custom list of sharepoint using web service

  
I need update an colunm of list sharepoint using web services. The code used is: private void button1_Click(object sender, EventArgs e)         {             try             {                   WSLists.Lists listService = new Lists();                 listService.Credentials = new System.Net.NetworkCredential("Usuario1", "Password", "Dominio");                 System.Xml.XmlDocument doc = new System.Xml.XmlDocument();                 System.Xml.XmlNode ndListView = listService.GetListAndView("LIST_Test ", "");                 string strListID = ndListView.ChildNodes[0].Attributes["Name"].Value;                 string strViewID = ndListView.ChildNodes[1].Attributes["Name"].Value;         

how to deploy a workflow design in SharePoint Designer 2007 in a list from development server to pro

  

how to deploy a workflow design in SharePoint Designer 2007 in a list from development server to production server. 

 i create a workflow in a list with SPD 2007 . I want to deploy it to production server who i can do this.


Thanks and Regards Er.Pradipta Nayak

Update a record in a SharePoint list using web services

  


Hi all,


I am trying to update one field in a record on a SharePoint list. I am using the code below to do this. The thing is it is tossing an error:


Unexpected end of file has occurred. The following elements are not closed: Method. Line 1, position 29.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Xml.XmlException: Unexpected end of file has occurred. The following elements are not closed: Method. Line 1, position 29.

Source Error:

Line 791:
Line 792:    /* Update the inspire field to exported*/
Line 793:    batchElement.InnerXml += "<Method ID='1' Cmd='Update'>";

Line 794:    batchElement.InnerXml += "<Field Name='ID'>6</Field>";
Line 795:    batchElement.InnerXml += "<Field Name='inpsire'>new</Field>";



As I understand; I create a method and then cmd update. I then give the ID of the record th

SharePoint 2010 Approval workflow based on list criteria

  

Hello All

I have been requested to create an Approval workflow for a list with 3 columns - Title, Category and Price. The Category field has 3 options - Minor, Moderate and Major.

If the Category is Minor the approval is sent to the Project Manager, and after approval it is sent to the Manager for approval.

How can I accomplish this using SharePoint Designer 2010? Can I modify the OOTB approval workflow, if yes how?

What other options do I have? This is really urgent.

Thank you for any responses.

Cheers

Yoshi

 


Update Infopath Fields with SharePoint Designer Workflow

  

Hi All,

Is there any way to update InfoPath Field and column with SharePoint Designer Workflow? I have an InfoPath Form Library on which I have published an InfoPath form. Now I want to change values of submitted infopath forms using SharePoint Designer Workflows ?

For your Information:

I am using SharePoint 2007 updated with SP2.

 

Regards..

 


Update Infopath Fields with SharePoint Designer Workflow

  

Hi All,

Is there any way to update InfoPath Field and column with SharePoint Designer Workflow? I have an InfoPath Form Library on which I have published an InfoPath form. Now I want to change values of submitted infopath forms using SharePoint Designer Workflows ?

For your Information:

I am using SharePoint 2007 updated with SP2.


Categories: 
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