INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

How to insert data from SQL server to Sharepoint list using web service

How to insert data from SQL server to Sharepoint list using web service

(OP)
Hi Team

I have an idea how to load data from SQL server to SharePoint and vice versa using SharePoint list adaptors .This adaptors work fine and work like magic but because of security compliances my client does not allow this adaptor to use.

I have used web service and found some C# Code to fetch the SharePoint list data in SQL server.I am not very good in C# coding ,This code was given by the other SSIS + C# developer, I have just mentioned my list name and columns name only to fetch the data from SharePoint list.
This code is used in script component.

Now what I need here that would like to know the C# Code which can insert the data from SQL server to SharePoint list using web service (Why I am repeating here web service because we only have this option left with us)

Can someone please assist or suggest me only web service option to load
data from SQL server table to SharePoint list so that I can use that code in script complonent in SSIS.

I have done following work around

1. Web service is ready.
2. Used web service to fetch data from SharePoint list to SQL server.
3. Need to know the way to load SQL server data back in SharePoint list.

Any help regarding web service will be much appreciated.

Thanks
vijay

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close