Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
wastebrain
Starting Member
1 Post |
 Posted - 2007-12-10 : 13:46:14
|
| Hi,I've a problem with excel destination spread sheet.I've created a package which pulls the data from sql server and load it into excel sheet.The main thing Ive to do is I've to create different destination tables(work sheets) for different data.i.e.,The source is a sql query which pulls the data in groupwise with group by clause.So,I've to create individual work sheet for each group with that data.How it can be done.Please, advice me.Thanks in advance. |
|
|
tm
Posting Yak Master
160 Posts |
Posted - 2007-12-10 : 16:30:21
|
| Should this be a case of copy and past and changing your Excel Destination Property to reference the worksheet you require?Or am I missing something?For instance I tested with simple package .. Created 1 source OLEDB to database in "Connection Manager".Create 1 EXCEL destination connection in "Connection Manager".Create 2 Control Flow >> Data Flow Task and within each one have your Data Flow Destination ~ Excel Destination >> Edit >> Properties >> "Name of the Excel sheet" to different sheets to populate. |
 |
|
|
|
|
|
Excel Destination spread sheet