views:

133

answers:

3

Hi,

I am using SSIS to transfer data from MS SQl server as data source and Sharepoint list as data destination. Now, I need to fire an update command on the sharepoint list. Please guide me to implement this.

A: 

See http://sqlsrvintegrationsrv.codeplex.com/releases/view/17652

unclepaul84
Hi apul, thanks for the reply. I still could not understand how to update the list. I have inserted the data from sql to sharepoint list. The "ID" columnin sharepoint list is : I believe autogenerated, so i could not map it to anything. How do I update then....
Sushant
A: 

Hi all, I used the information from below link. Please download the source code and mplement as per your needs. Works perfectly.

Sushant
A: 

If you can use third-party solutions, check the commercial CozyRoc SSIS+ . It includes components for integration with Microsoft SharePoint.

CozyRoc