I have created a SQL Server 2000 DTS package that exports data to an excel
workbook.

It runs successfully every time that I execute it from the DTS portion of
Enterprise Manager.

I created a job by selecting Schedule Package and when I attempt to run the
job it fails on the first step which is to drop the table that is created
prior to the export. The job runs under the context of the same Windows login
as the one I am using when I successfully run the package in Ent Mgr.

Here is the error message:
Executed as user: PAG-SQL-03\SYSTEM. ...ting...
DTSRun OnStart: Drop table Data_Fees_in_SQL Step
DTSRun OnError: Drop table Data_Fees_in_SQL Step, Error = -2147217911
(80040E09)
Error string: Cannot modify the design of table 'Data_Fees_in_SQL'.
It is in a read-only database.
Error source: Microsoft JET Database Engine
Help file:
Help context: 5003027
Error Detail Records:
Error: -2147217911 (80040E09);
Provider Error: -538642193 (DFE4F8EF)

Thx,

Joe

You are overriding the data in excel everytime the package is executed. try
to remove the read-only property of your excel file

"elpepe" wrote: