InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 18 May 2013 04:03:23 GMT20http://www.sqlservercentral.com/Forums/Topic1422555-364-1.aspxMy WSDL is not that strong but I would go along the lines of using a dataflow in the format:Data source to get your data which feeds a script component synchronous transform which:Set the input USDAmount column to read/writeIn the PreProcess method sets up the WSDLIn the ProcessInputRow method pass the date, currency code and amount to the WSDL and uses the object attribute to apply the conversion to the currency value and store the result in the USDAmount column.The performance will not be great since the web service will be called for each row.If possible pre-sort your amounts by date and currency. This means that you can optimise the script component to only access the web service and get the exchange rate on a change of date and/or currencyThu, 21 Feb 2013 12:47:05 GMTjm99http://www.sqlservercentral.com/Forums/Topic1422555-364-1.aspxHello,has anyone used SSIS to convert currency based on a date from a table?For example;If I have a table with the following Columns;Amount Currency USDAmount InvoiceDate1000 CAD NULL NULLI 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.ThanksThu, 21 Feb 2013 06:54:15 GMTmbrady5