I am trying to prove I can use SSIS to connect to a web service.ÃÂ The WS I am trying to connect to was developed by a vendor and covered by a NDA, but I was able to reproduce the issue with a public WS.
Here are the steps to reproduce the issue:
In the Web Services Connection Manager, I entered http://office.microsoft.com/Research/Providers/MoneyCentral.asmx?wsdl in the URL window.ÃÂ I am able to successfully "test" the connection
I pasted the above link into IE and saved the resulting XML as a .wsdl file on my local machine.ÃÂ In the Web Services Task Editor, General Tab, I specify the path to the .wsdl file and click on "Download WSDL" button.ÃÂ No Issues
When I click on "Input" and select "MoneyCentralRemote"ÃÂ from the drop-down for Service, I receive an error message saying "This version of the Web Services Description Language (WSDL) is not supported"
So the questions are:
Did I perform the above steps correctly?
What WSDL versions are supported in SSIS?
How can I tell what WSDL version was used to create the .wsdl I am trying to access?
If the WSDL is an unsupported version, is there a work-around to fix the issue?
View Complete Post