Populate monthly table from quaterly data I have below excel file that I am loading to ssis. The problem is that the granualrity for the date dimension is by month. Is there a way to load the data so that for Jan, Feb &amp; Mar the value is -0.10409. April May June is 0.662643 and so on

Cheers

Aidan
If your date dimension has an Qtr Number attribute, you could join the import data to the date dimension on that field and you would create the required rows.