Hi, I have a situation where i need to apply look up a range. I have distance_from_dealer column in customer transaction table. I have all the ranges defined in dim.distance table. this has start_range and end_range. So Now i need to match the distance_from_dealer to the between of start_range and end_range. here is the image. How do i do that in ssis. Thanks for any help.

here are a couple of solutions: http://microsoft-ssis.blogspot.nl/2011/01/lookup-slowly-changing-dimension-type.html for example via the advanced, but that's slowww if you have a lot of rows. Please mark the post as answered if it answers your question | My SSIS Blog: http://microsoft-ssis.blogspot.com | Twitter

Or modify the SQL command property for the Lookup componend tvia the DFT properties selection. Abhinav http://bishtabhinav.wordpress.com/