asked
Input problems with SSIS 2008 Web Service Task
Hi I have a SSIS 2008 package which will (hopefully) utilise a recordset destination passed to a For Each Loop. Inside this loop container is a Web Service task (WST). WST has a tested and connected HTTP connection. I have downloaded the wsdl file - by creating it, saving it and pointing the WSDLFile property to the saved ??.wsdl file with Overwrite = true. Download is successful. However, moving to the Input tab I have no ServiceName to select from, I have no Methods. What is wrong? Where have I stuffed it? The web service is designed to accept parameter values from the outer recordset destination, and use these to add new records to Active Directory. The Web Service it self works but I can't get near it from SSIS
There seems to be a bug in creating a Web Service Task, when downloading the WSDL-file by using the automatic download of WSDL-file from BI-Studio. A workaround that worked fine for me is to: - Use **Disco.exe** to download a WSDL-file. - Point to the downloaded .wsdl-file, without using "Download WSDL"-button in the designer. That worked for me, then I can select ServiceName and Methods. I created a simple sample package reading HumanResources.Department from AdventureWorks, and in the ForEach-Loop I consume a web service which writes a string value to the Application Event Log. I have got it working, to confirm that it's possible to setup a Web Service task inside a ForEach Loop Container. But I did run into the same problem you describe when I first create the HTTP Connection Manager and then used "automatic" download of .wsdl-file.
