"elpepe" wrote:

> 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
>
>
>
>
>