Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Read from Excel write to Excel named sheet Expand / Collapse
Author
Message
Posted Tuesday, January 19, 2010 1:00 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, November 12, 2012 4:54 PM
Points: 54, Visits: 816
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!
Post #850072
Posted Wednesday, January 20, 2010 1:30 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 7:04 PM
Points: 1,114, Visits: 2,192
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/

Post #850804
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse