Nonstandard SSIS lookup

Posted by Stefan on Stack Overflow See other posts from Stack Overflow or by Stefan
Published on 2009-11-11T14:56:36Z Indexed on 2010/03/30 9:13 UTC
Read the original article Hit count: 394

Filed under:

I have a situation where I am trying to lookup a value in one table based on values in another table, using a BETWEEN operator and not an = operator.

In one table, I have a value "EffectiveDate". I want to get a Weight number from another table, but the other table has two fields: "Inception" and "Termination". What I want to do is extract the Weight from that table for use where the EffectiveDate is between Inception and Termination.

SSIS doesn't seem to provide a way to do this. It's good at matching one column to another column, but doesn't seem to allow one to many-column comparison/operations.

Am I missing anything? Is this possible to do somehow?

© Stack Overflow or respective owner

Related posts about ssis