Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ismailc
Constraint Violating Yak Guru
290 Posts |
 Posted - 2010-01-07 : 06:12:23
|
| 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! |
|
|
ismailc
Constraint Violating Yak Guru
290 Posts |
Posted - 2010-01-07 : 09:40:33
|
| 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! |
 |
|
|
|
|
|
Update a Sharepoint List in SSIS (Web Service)?