How to generate same records based on From Date and To Date

Hi All,

I want to generate number of records based on my begin date and end date.I am loading data from data source to DSO. My DSO contains Begin Date and End Date. I want to create Date field in the DSO as key field which will generate number of records. For example if I have date range as 02/04/2011 -- 02/14/2012. So in my DSO I want to see 10 records from 02/04,02/05,02/06 to 02/14 etc. Please suggest me the solution to implement in the routine.

Thanks

Ganesh Reddy.