Have Geek Brain

SSIS web service task cannot execute web service

I have a web service that is being called from my ssis.

Used to work in test mode, when you move to live environment I get the error:

[Web Service Task] Error: An error occurred with the following error message: "Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebserviceTaskException: Web method failed. Error: Object reference not set to object instance .. on Microsoft .SqlServer.Dts.Tasks.WebServiceTask.WebMethodInvokerProxy.InvokeMethod (DTSWebMethodInfo methodInfo, String serviceName, object connection) at Microsoft.SqlServer.Dts.Tasks.WebServicepenfoTask.WebServiceTaskUtil.WebServicepenfoTask.WebServiceTaskUtil.Variable at Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebServiceTask.executeThread () ".

We use a proxy to access the network. Could this be a proxy problem. how to solve?

thanks

+1


a source to share


5 answers


It was a simple proxy problem.



Don't forget to configure the proxy tab in the Http connection manager

+3


a source


To help diagnose this, you can try using a script task and add a service link or a web link to a web service. Call the service in a try / catch block and write ex.ToString () if you get an exception. This way you will be sure to get all the details and you can post them here when you edit your question.



+2


a source


It's also worth noting that SSIS cannot call services with spaces in their names. See below for details:

http://connect.microsoft.com/SQLServer/feedback/details/368606/ssis-web-service-task-cannot-call-services-with-a-space-in-the-name

This answer would save me time, so I am adding it in the hopes that it will save someone else.

+1


a source


I had the same problem, except that I was trying to pass an integer (Int32) as a parameter to the web service. It looks like the parameters of a web service in SSIS should always be strings.

0


a source


I am using SSIS 2017 and none of the solutions worked for me. But after changing the SQL Server used by the project from 2017 to 2016 (or whichever version of SQL was installed), I was able to successfully run the WebService task.

Hope will help someone.

enter image description here

0


a source






More articles:


All Articles