I am trying to create a package using standard SSIS features. I will be using a webservice and connect to a SAP server to access tables and extract data to SQL Server database. Using the WebService task, in the General tab I am able to create a Httpconnection and test the connection which is successful. Next I was able to successfully download a WSDL file and set the OverwriteWSDL to True. In the Input tab, I am able to find and select the service and Method and left the WebMethodDocumentation as blank. In the output tab I selected File Connection for Output Type and gave filename. I haven’t done anything in the Expressions tab at this point. When I build the solution there is no error at this point. When I Start Debugging the package, I am getting the following error. [Web Service Task] Error: An error occurred with the following error message: "Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebserviceTaskException: Could not execute the Web method. The error is: Method 'ProxyNamespace.RFC_READ_TABLEService.RFC_READ_TABLE' not found.. at Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebMethodInvokerProxy.InvokeMethod(DTSWebMethodInfo methodInfo, String serviceName, Object connection) at Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebServiceTaskUtil.Invoke(DTSWebMethodInfo methodInfo, String serviceName, Object connection, VariableDispenser taskVariableDispenser) at Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebServiceTask.executeThread()". Does anybody have suggestions what the issue is and what needs to be done to fix the issue?

Hi Learner, How you configured the HTTP Connection Manager ? Please provide more details to help you, Regards, Tarek Ghazali Sql Server MVP

Hi Learner, How you configured the HTTP Connection Manager ? Please provide more details to help you, Regards, Tarek Ghazali Sql Server MVP

Hello Tarek, Thanks for your prompt response. Here is how I configured the HTTP Connection Manager. 1. In the General tab in Web Service Task Editor, HttpConnection created a New Connection. 2. In the Server tab, I used the SAP https server URL where the web service is and checked credentials and entered my uname and pass and checked Use client certificate and tested the connection which says successful. 3. In the Proxy tab, I left everything to default so the "Use Proxy" is unchecked at this point. And believe this is where I need to set something. Set the proxy and declare a URL but the SSIS is not accepting https server URL nor it is accepting the location (local machine) of the file where the wsdl is downloaded. Please let me know if you need more details on any other settings. Thanks again for your assistance.

Hello Tarek, Thanks for your prompt response. Here is how I configured the HTTP Connection Manager. 1. In the General tab in Web Service Task Editor, HttpConnection created a New Connection. 2. In the Server tab, I used the SAP https server URL where the web service is and checked credentials and entered my uname and pass and checked Use client certificate and tested the connection which says successful. 3. In the Proxy tab, I left everything to default so the "Use Proxy" is unchecked at this point. And believe this is where I need to set something. Set the proxy and declare a URL but the SSIS is not accepting https server URL nor it is accepting the location (local machine) of the file where the wsdl is downloaded. Please let me know if you need more details on any other settings. Thanks again for your assistance.

Hi Learner, Try to access the web service from internet explorer: http://..../file.asmx since i want to make sure that the connection is working fine, Please check if you define any proxy server by following these steps : open IE -> tools -> internet options - > connections--> lan settings, Regards, Tarek Ghazali SQL Server MVP

Hi Learner, Try to access the web service from internet explorer: http://..../file.asmx since i want to make sure that the connection is working fine, Please check if you define any proxy server by following these steps : open IE -> tools -> internet options - > connections--> lan settings, Regards, Tarek Ghazali SQL Server MVP

Some problem with your web service. First try to access your web service from your local browser.

Some problem with your web service. First try to access your web service from your local browser.

If it works on browser, Check your wsdl document for problems. The problem should be here. Else the problem will be in namespaces.

If it works on browser, Check your wsdl document for problems. The problem should be here. Else the problem will be in namespaces.

Tarek, I tried to access the webservice from IE and I can see the xml version and the elements / methods in the IE browser. But I just want to mention that the webservice is not in the .asmx format. The https directly point to the webservice name and the SAP client #. Will it make any difference? I didn't setup the webservice so I don't have much knowledge about this. As for my proxy server setting, I followed the steps you mentioned above and verified the settings. Right now "Use a Proxy Server for your LAN" is unchecked. Should it be any different? Thanks.

Tarek, I tried to access the webservice from IE and I can see the xml version and the elements / methods in the IE browser. But I just want to mention that the webservice is not in the .asmx format. The https directly point to the webservice name and the SAP client #. Will it make any difference? I didn't setup the webservice so I don't have much knowledge about this. As for my proxy server setting, I followed the steps you mentioned above and verified the settings. Right now "Use a Proxy Server for your LAN" is unchecked. Should it be any different? Thanks.

Hello Manikandan, Thanks for your response. I can access the web service from my browser. What kind of problems are possible in the wsdl document? What should I look for? Could you pls be specific?

Hello Manikandan, Thanks for your response. I can access the web service from my browser. What kind of problems are possible in the wsdl document? What should I look for? Could you pls be specific?

Any ideas anyone?

Any ideas anyone?

Hi All That problem is: Input parameter is not correct. For example : In fact need Datetime type,But gave it the other types. webserviceDatetimeStringProxyNamespace ......

Hi All That problem is: Input parameter is not correct. For example : In fact need Datetime type,But gave it the other types. webserviceDatetimeStringProxyNamespace ......