I am working on similar situation. What I did so far is that I transfered the rows from database in one worksheet of excel sheet. then I write macro to...
Make two excel file, one is template.xls and another is say destination.xls. Before transfer the data from oledb to destination.xls. Copy the template.xls to destination.xls by File system task