July 28, 2009 at 9:11 pm
To the Web Service And SSIS Gurus!
We are interfacing with an external vendor and trying to access their data through web services being called from SSIS. I know that they have developed their web services in Java and have given us the WSDL file.
The HTTPConnection Manager in SSIS looks for a URL. Had it been .NET I could have used the WSDL path and added an .asmx in the HTTP Connection Manager, I am not able to do that as I know the extension .asmx is .NET specific.
Does any one know what is the extension for JAva Web services? As I am no expert in Java/.NET and a SQL developer this might be a simple thing that I do not know how to achieve.
Your inputs is much appreciated!
Aparna
July 29, 2009 at 5:26 pm
For Anyone who would run into this situation. It was not the HTTPconnection Manager that was the issue but the WSDL file.
Their WSDL file had multiple virtual paths one to connect from intranet and one to connect from internet. When I pointed to one of the paths it worked fine.
ex: HTTP Connection manager of the type is a valid connection. http://a.com?WSDL.
Please check the WSDL file and see if there are multiple URL to get to the service
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply