Help with Web Services and SSIS - Programmers Heaven

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

Welcome to the new platform of Programmer's Heaven! We apologize for the inconvenience caused, if you visited us from a broken link of the previous version. The main reason to move to a new platform is to provide more effective and collaborative experience to you all. Please feel free to experience the new platform and use its exciting features. Contact us for any issue that you need to get clarified. We are more than happy to help you.

Help with Web Services and SSIS

CalebfCalebf Arizona, USPosts: 1Member

Hello

I am new to the community, as well as new to Web Services in a whole. I have succesfully implemented one web service project through SSIS through a different vendor, but on this vendor I am stumped.

First of all, here is the link to the list of web services: https://login.incontact.com/insidews/inSideWS.asmx"

Second of all, here is a link to the WSDL file I get from adding the ?WSDL to the end of the link above: https://login.incontact.com/insidews/inSideWS.asmx?wsdl

My goal is to use the command "Agent_GetList" to pull data from the Web Service, into SSIS, then into SQL Server. When I use the link above, and generate a WSDL from the link by clicking "Download WSDL" from the Web Service Task in SSIS, it then gives me a list of methods to pull. The "Agent_GetList" is included in these methods, yet there is no where to verify my password, or any other login information. When I use the "Agent_GetList" as the method, and try and test Executing the Task in SSIS, I get the following error:

[Web Service Task] Error: An error occurred with the following error

message:

"Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebserviceTaskException

The Web Service threw an error during method execution. The error

is: System.Web.Services.Protocols.SoapException: Server was unable to

process request. ---> System.NullReferenceException: Object reference

not set to an instance of an object. at

inSideWebService.proxySoapExtensions.ProcessMessage(SoapMessage

message) at

System.Web.Services.Protocols.SoapMessage.RunExtensions

(SoapExtension[] extensions, Boolean throwOnException) at

System.Web.Services.Protocols.SoapServerProtocol.ReadParameters()

at

System.Web.Services.Protocols.WebServiceHandler.CoreProcessRequest()

--- End of inner exception stack trace ---. at

Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebMethodInvokerProxy.In

vokeMethod(DTSWebMethodInfo methodInfo, String serviceName, Object

connection) at

Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebServiceTaskUtil.Invok

e(DTSWebMethodInfo methodInfo, String serviceName, Object connection,

VariableDispenser taskVariableDispenser) at

Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebServiceTask.executeTh

read()".

I simply just want to pull the data from Agent_GetList. Please help with what I am doing wrong, or anything I may be missing.

Thank you

Sign In or Register to comment.