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?
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?
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.