Win a copy of Java EE 8 High Performance this week in the Java/Jakarta EE forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

Help pulling Web Service through SSIS  RSS feed

Posts: 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

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:"

Second of all, here is a link to the WSDL file I get from adding the ?WSDL to the end of the link above:

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 that is attached in the .txt document.

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

[Thumbnail for SSIS-Error.PNG]
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!