Update a Sharepoint List in SSIS (Web Service)?

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!

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!