Dynamic currency converter

  • 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.

  • Any help guys..

  • Quick question, as looks like the HTTP Connection Manager is not correctly configured, can you post the connection configuration?

    😎

  • Thank you for your response

    Here is the screenshot of the http connection manager (no proxy)

  • Obviously the Test Connection is successful?

    😎

    Don't have SSDT available at the moment, so I cannot do much more than point you to this article: Example using Web Services with SQL Server Integration Services[/url]

  • Thank you buddy..whatever way you have helped me is awesome

    btw the article you suggested is almost like the same one I am following:-P

  • I'd try the url without the "WSDL"...that usually points to a file containing the structure of the expected output, and is typically not used in the url when trying to extract data.

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply