How can I use a Data Flow Task to read an Excel file and write it to a named sheet in my destination workbook? I am trying to create a workbook from different Excel files that were create from SSRS reports. The content of the source Excel files is not charts, calculations or anything like that. The Excel files are what you would get if you Exported your report fom report server to Excel. Hope that helps!