-
How to refresh Excel data from DTS ActiveX Script Task
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|