Please start any new threads on our new site at We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SSIS and Import/Export (2005)
 Dynamic currency converter

Author  Topic 

Yak Posting Veteran

96 Posts

Posted - 2015-04-03 : 19:27:36
I am following the guide provided HERE to build a currency converter. The static converter works very fine, but I am having issue while building dynamic version of it.

Basically, I have designed it as below:

1) Data flow task: Uses a sql query to get a distinct list of all the currencies being used in the fact table and store into a recordset object 'ObjCurrency'

2) Foreach loop container:

Iterates through all the values in 'ObjCurrency' and each value gets stored in CurrencyCode

2.1) Script task: A message box is used to show the current currency code

2.2) Web service task: As stated in the above guide, I am sending the CurrencyCode variable as a 'FromCurrency' and 'USD' is my 'ToCurrency' to get a dynamic WSDL for every CurrencyCode

2.3) XML task: Used to get 'ConversionRateResponse'

2.4) ScriptTask1: A message box is used to show the current ConversionRateResponse

I am getting an error at 2.2 and the error is:

[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()".
Can someone please help me with this?

Thank you in advance.

Yak Posting Veteran

96 Posts

Posted - 2015-04-04 : 00:43:08
Any help guys..
Go to Top of Page

Master Smack Fu Yak Hacker

2780 Posts

Posted - 2015-04-04 : 08:35:34
Ssis cannot find that method on that web site.
Go to Top of Page

- Advertisement -