mbrady5 (2/22/2013)
There will not be an exact (date match) in the exchange view. This is updated once per week.What I was thinking about doing is adding a week and year number column to the source and the lookup view so I could match on that?
What confuses me the most is the logic for the lookup and how it works.
Any good starting points? (Besides dragging it on the canvas):-)
There's no magic in it - all that you are doing is matching one or more columns in your source data to one or more in the lookup table (think of it as an inner join) - and then including any other columns (in your case exchange rate) from the lookup table in your data flow.
But it needs to be an exact match, one way or another. If it were me, I would probably use a date tally table to 'explode' the currency view to include all dates and then match against that.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.