Retrieving data from Dim Time using another table

[e***@gmail.com]

Hi

i want to get all rows from 1 table (Dim Promotion) that has Start
Date and End Date
and retrive all rows from Dim Time that answer the condtion :
DimTime.DayKey Between (Start Date and End Date)
how can i do it in Data Flow ?

[Todd C]

Can you be more specific? You want TWO result sets (one from DimPromotion and
one from DimTime) or only ONE? If one, how are the tables related? Is DimTime
linked to DimPromotion on TWO fields (StartDate and EndDate) ?

Are both tables in the same database or server? If so, can you write a T-SQL
SELECT statement that joins them? (Sometimes doing so is actually faster than
creating fancy Merge Join Transformations in an SSIS Data Flow.)

Keep us posted.

--------
Todd C

Post by e***@gmail.com
Hi
i want to get all rows from 1 table (Dim Promotion) that has Start
Date and End Date
DimTime.DayKey Between (Start Date and End Date)
how can i do it in Data Flow ?