I need to 1.export data from sql to excel(DTS:it's done) 2.After excel document is updated i have to calculate the monthly sum 3.after this i need create monthly chart. Is it possible to accomplish from DTS package on sql?
For that you should post in MS Office forums for Excel topic, I don't see any reference to control these charts from SQL server to Excel. _________ Satya SKJ Moderator SQL-Server-Performance.Com