I have problems with using variables in the From and To Currency

• richardcinman

  Grasshopper

  Points: 11

  More actions

  October 13, 2015 at 4:53 pm

  #321451

  I created a proof of concept package with the Web Service Task using hard coded values from the drop down list and it worked fine. I then tried to populate From and To using Variables and I get

  [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()".

  Any help would be appreciated.