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 |
|
Maha
Starting Member
2 Posts |
 Posted - 2012-01-18 : 06:18:56
|
| Good morning everyone,I am exporting some data from SQL to Excel using the export/import wizard.I save an SSIS package, that extracts these SQL data into an excel file. I run this package everytime I need to get this data and everything is working fine.The problem now is that I want this data to get extracted into a pie chart in the excel file not a normal table, so is that possible using the export/import wizard or modifying in the code of the SSIS package (.dtsx)? If no, any suggestions about how could this be done?Thank you in advance.Maha |
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2012-01-18 : 07:21:35
|
| My knowledge of Excel is only superficial, but the way I have created pie-charts in Excel is by using underlying tabular data. So if you export the data to Excel in tabular form, and if there is a pie-chart driven off of that tabular data, wouldn't that satisfy your requirements? |
 |
|
|
Maha
Starting Member
2 Posts |
Posted - 2012-01-18 : 07:56:54
|
| The thing is that I want it automated.This Excel file is automatically generated on the 1st of each month, so I dont want to have to open the report each time and create a pie chart, I just want that to happen automatically so that the report file is created with the pie chart each time.Maha |
|
|
|
Summer9
Starting Member
1 Post |
|
|
|
|
|
Export Data from SQL to Excel pie chart