I would really appreciate it if someone can assist me with this problem:
I have a Integration Services Project in business Intelligence Studio that uses a Web Service Task to connect to a web service on a different machine. Running the package throws the error
"Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebserviceTaskException: The Web Service threw an error during method execution. The error is: Unable to connect to the remote server."
- I can browse the web service (.asmx) using Internet Explorer
- In setting up the HTTP connection manager in BI studio I CAN click on the "Test connection" tab successfully.
-I am not using "localhost" as a reference but DNSname/Machine name
Any help would be great thanks.