Read from Excel write to Excel named sheet
-
Greetings!
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!
Thanks!
-
yosiasz (1/19/2010)
Greetings!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!
Thanks!
You have standard Excel Source and Destination components in the data flow task. Have you tried using them?
---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply