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.
Help us to help you. For better, quicker and more-focused answers to your questions, consider following the advice in this
If the answer to your question can be found with a brief Google search, please perform the search yourself, rather than expecting one of the SSC members to do it for you.
Please surround any code or links you post with the appropriate IFCode formatting tags. It helps readability a lot.