we thought about implementing this report in SSIS, but we are dealing with 24 months worth of sales data, as well quarterly and yearly data, i have dynamically changing columns

For Example : for the Month for August 2012, my table columns names will be

tblSalesData : SalesId, Name, Address, Zip,[Aug'12],[Jul'12],[Jun'12],[May'12]...... [Sep'10],[12 Months Ended Aug'12], [Q2'12],[Q1'12],[Q4'11].....[Q4'10]

for the Month of September 2012, my table columns names will be

tblSalesData : SalesId, Name, Address, Zip,[Aug'12],[Jul'12],[Jun'12],[May'12]...... [Sep'10],[12 Months Ended Sep'12],[ Q3'12] [Q2'12],[Q1'12],[Q4'11].....[Q4'10] , i have built this column names using dynamic sql

In SSIS, is there a way to map this changing column names in Data Flow Task ...?

may i know your thoughts on this....? appreciate your help..

Note: No Partial Quarters are allowed, so for August we start from [Q2'12], where as September we start from [Q3'12]