April 3, 2015 at 5:27 pm
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.
April 3, 2015 at 10:43 pm
Any help guys..
April 3, 2015 at 11:28 pm
Quick question, as looks like the HTTP Connection Manager is not correctly configured, can you post the connection configuration?
😎
April 4, 2015 at 12:16 am
Thank you for your response
Here is the screenshot of the http connection manager (no proxy)
April 4, 2015 at 1:07 am
April 4, 2015 at 1:17 am
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
April 6, 2015 at 9:28 am
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