I'm running a DTS package which updates an Excel
spreadsheet. I want to save the spreadsheet in HTML
format. I've set the spreadsheet to publish so that the
HTML page is updated when the spreadsheet is saved. This
works when the spreadsheet is manually saved. I've
written a macro which saves the spreadsheet on exit. This
also works manually. However when the DTS package runs
and the spreadsheet is updated the HTML page is not
updated. Does anyone know how I can get the HTML page to
be updated overnight as it needs to be available for
start of day?

Any errors involved here ?
Set the package to fail on first error (Right click whitespace | Properties)
Does the Excel Spreadsheet get updated OK ?
This works when run manually so your process would seem to be fine. Have a
look at this for the nuances of executing a package as a job.

http://support.microsoft.com/?kbid=269074



--
--

Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org

"Margaret" <anonymous (AT) discussions (DOT) microsoft.com> wrote

No errors. The spreadsheet is updated OK. It's the HTML
page that isn't updated.