Hi,

I have an ActiveX script in my DTS Package, which generates excel reports ,
I have been running this package for almost one year, last night it failed
giving a message "Permission denied : Create Object" at line 52 , The stmt i
found at line 52 is "Set objExcel = CreateObject("Excel.Application")". The
script is running under admin account with full permissions, the package
version date is 07/14/2004 , when i see logs for 7/14 version it run
everyday till yesterday.

windows 2000 advanced server/ sql server 2000 enterprise ver.

Any hints on the issue .

Thanks,
Subbu.

In message <OO92Q#keEHA.2908 (AT) TK2MSFTNGP10 (DOT) phx.gbl>, Subbaiahd
<subbaiahd (AT) hotmail (DOT) com> writes
298725 - PRB: Scheduled DTS Package Fails With "Permission Denied:
CreateObject"
(http://support.microsoft.com/?kbid=298725)

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org

If this has been running happily for a long time and NOTHING has changed in
DTS or your permissions then something external to this HAS to have changed.
My guess would be that maybe the Excel dlls on the server got stamped and
need to be reregistered.

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.konesans.com - Consultancy from the people who know


"Subbaiahd" <subbaiahd (AT) hotmail (DOT) com> wrote