has anyone used SSIS to convert currency based on a date from a table?
If I have a table with the following Columns;
Amount Currency USDAmount InvoiceDate
1000 CAD NULL NULL
I would like to possibly use a free web service that will look at my Invoice Date and do the Math based on the Spot currency rate for that time and return the converted US Dollar amount.