I have an Excel spreadsheet that contains a pivot table containing data from SQL Server. I have a DTS package that updates this data in SQL Server. What I want to do within this DTS package is after the data is updated in SQL Server, I want to refresh the data in this Excel spreadsheet and then email a copy of it to several people. Can't this be done fairly easily from an ActiveX Script task using the Spreadsheet Component's Object Model?

I think all I need to do is get a reference to the spreadsheet, tell it to refresh its data, and save it. Then I can add a mail step in the DTS package and attach this Excel file to the email that is sent. Right? How?

Thanks