Hi,
does SSIS 2008 will finally offer a "between lookup"?
the current lookup support only the equal (=) operator, but when we play with Type 2 SCD dimensions, its important to also test the dates using a between.
or better, the operator used in the comparison should be an option instead of a equal only.
Thanks.
You can already do such lookup in SSIS 2005 using Partial or None cache Lookup mode.
Neither SSIS 2005, nor SSIS 2008 support such lookups in Full cache mode.
but its a row by row process and everytime the system execute the query against the lookup database.
with million of rows and more to load , this is not efficient.
at least, do you plan to improve the lookup component?
Willgart1 wrote:
but its a row by row process and everytime the system execute the query against the lookup database.
with million of rows and more to load , this is not efficient.
at least, do you plan to improve the lookup component?
Hi Willgart1,
There has been no announcement of changes to the lookup functionality in SSIS2008. Announcements on new functionality are not being made until Microsoft can be absolutely sure that that new functionality will make it - in other words they are announcing stuff after they've built it rather than before. Hence, because there has been no announcement doesn't mean there won't be anything. I'm keeping my fingers crossed on improvements to LOOKUP.
-Jamie
Alberto Ferrari wrote a Range Lookup component that we presented at an italian conference last month (www.sqlconference.it).
In the next days we should finish a little documentation of the component and we will publish it on www.sqlbi.eu
It works in memory and is pretty flexible in the way you can configure the match expression.
Just a few days... if you subscribe to the newsletter on www.sqlbi.eu you'll receive an update when it'll be available, otherwise you can check our blogs (http://www.sqljunkies.com/weblog/aferrari/ and http://sqlblog.com/blogs/marco_russo/).
Marco Russo
http://sqlblog.com/blogs/marco_russo
