Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
tpavan7329
Starting Member
18 Posts |
 Posted - 2012-01-19 : 07:08:40
|
| I was trying use web service task with HTTP Connection to get currency exchange rates. My requirement was to get all non-USA currency exchange rates converted to USD. I have load all the exchange rates into a sql server table.when i try to plug in to and from countries package was successful but when i try to use variable for input tab it throws me below error.Can anyone help me on this?[Web Service Task] Error: An error occurred with the following error message: "Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebserviceTaskException: Could not execute the Web method. The error is: Method 'ProxyNamespace.CurrencyConvertor.ConversionRate' not found.. at Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebMethodInvokerProxy.InvokeMethod(DTSWebMethodInfo methodInfo, String serviceName, Object connection) at Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebServiceTaskUtil.Invoke(DTSWebMethodInfo methodInfo, String serviceName, Object connection, VariableDispenser taskVariableDispenser) at Microsoft.SqlServer.Dts.Tasks.WebServiceTask.WebServiceTask.executeThread()".T Pavan Kumar |
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2012-01-19 : 07:39:24
|
| Do you have access to the source code for the web service? Without looking at it, hard to say why constants work and variables don't. It very well could be that the web method is constructing a SQL query using the exact string you supply into the query string rather than treating it as a variable. |
 |
|
|
|
|
|
Web Service Task Error