MSBI

Hi All, Here I wanted to show you how we can implement Yahoo! Finance Currency Convertor API using C# . Note: This is based on Standard: ISO_4217. I am using a Console application to get the results. Logic: Yahoo! Finance API convertor will calculate, what is value of 1 unit in current currency system against other currency system we wanted to convert. Use the result and multiply with Amnt you need to convert. E.g., (INR: Indian Rupees; USD: US Dollar) 1 INR == 0.016 USD, then how much is 300 INR equals to? Simple math, we do using a cross multiplication, We get,             X= 0.016*300 This is the same logic; we are going to apply here. using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Threading.Tasks; using System.Web; using System.Net; using System.Diagnostics; using System.Text.RegularExpressions; namespace LiveCurrencyconv

[OLE DB Source] Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "\foo\c$\bar" failed with error code 0xC0209303. There may be error messages posted before this with more information on why the AcquireConnection method call failed. If you face this error, then, go to project properties and select Debugging option from Configuration Properties and set Run64Bit mode to “False”.  

If you get “ SSIS: OleDB Data source: cannot retrieve the column code page info from the OLE DB provider “ error, then follow these steps to resolve. Go to the SSIS project properties page Ø   Then Click Debugging under configuration properties Ø   Select “Run64BitRuntime” property to false Ø   Save the project Ø   RUN Build againThen check the package runs to a successful completion.