Need a help to implement this logic in SSIS.

Question

Need a help to implement this logic in SSIS.

Viewing 2 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Ed Zann SSCrazy Eights Points: 8694 More actions · Answer 1

If I were doing this, I would modify the Currency table to include [ExchangeStartDate] and [ExchangeEndDate] fields. Then I would use a range in the join clause of the query:

FROM Invoices inv

INNER JOIN Currency cur

ON inv.InvoiceDate BETWEEN cur.ExchangeStartDate AND cur.ExchangeEndDate

I'm sure there are several other approaches to this as well. This is really more of a T-SQL question.

Elliott Whitlow SSC Guru Points: 102402 More actions · Answer 2

I think Ed is on the right track, doing this at the DB instead of in SSIS is a better approach. SSIS does not offer a between type lookup, the records much match exactly. SQL would do a much better job and much faster on this kind of query.

CEWII