SQL Server Performance

Update a Sharepoint List in SSIS (Web Service)?

Discussion in 'SQL Server 2005 Integration Services' started by Ismailc, Jan 7, 2010.

  1. Ismailc New Member

    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!
  2. Ismailc New Member

    I managed to update the listBut 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!

Share This Page