Update a Sharepoint List in SSIS (Web Service)?

• ismail casper

  SSCrazy

  Points: 2003

  More actions

  January 7, 2010 at 4:17 am

  #208710

  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!

• ismail casper

  SSCrazy

  Points: 2003

  More actions

  January 7, 2010 at 7:43 am

  #1100218

  I managed to update the list

  But my source is returning all the items in the list.

  I need to add a CamlQuery so that it returns only the record I want.

  Filter a record eg. where item list ID="1"

  I created the var but need the filter string & how would i specify the var in the CamlQuery property?

  Please Assist!

• COZYROC

  One Orange Chip

  Points: 28499

  More actions

  June 8, 2010 at 4:21 pm

  #1177723

  If you can use third-party solutions, check the commercial CozyRoc SharePoint integration. These are the relevant components:

  * SharePoint Source SSIS Data Flow Component

  * SharePoint Destination SSIS Data Flow Component

  * SharePoint SSIS Connection Manager

  Batch insert and update is also supported.

  ---
  SSIS Tasks Components Scripts Services | http://www.cozyroc.com/