October 10, 2007 at 4:40 pm
In SSIS i try to use a Web Service Task for a Web Service of Sharepoint (WSS 3.0).
Web Service = Lists
Method = GetListItems
1 - Create HTTP connection (http://servername[/i%5D/_vti_bin/lists.asmx)
2- Download and save the wsdl file.
3 - Choose the Web Service = Lists
4 - Try to choose the method and the List Box is empty....
Anything wrong?
November 18, 2007 at 4:41 pm
Depending upon what you are trying to achieve, you may want to consider calling the web service from a script task or script component. I describe exactly how this can be achieved in my blog SSIS: Calling SharePoint web services from the data flow
Also, take a look at Cleaning Address Data with SSIS Using a Web Service[/url] which also outlines how to call web services from SSIS scripts.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply