Post reply

Why Web Service Task don't work?

  • October 10, 2007 at 4:40 pm

    #198887

    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/_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?

  • October 25, 2007 at 5:37 pm

    #745523

    Well, there's a tip...

    🙂

    LINK

  • November 18, 2007 at 4:41 pm

    #752120

    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 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply