Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-04-08 : 11:55:30
|
Judie writes "I am trying to set up a schedule to run a package that works great as a local package. But when I schedule it through SQL Server Agent, it bombs.
All the package is doing is getting data from SQL Server A, exporting it to a .xls file on Server B.
The rights on each server is set wide open, now, just to get this job to work but it still is not working.
Any suggestions? Or... Is there a way to schedule the package another way?
Thank you for any suggestions.
... DTSRun: Executing...
DTSRun OnStart: Drop table Results Step
DTSRun OnError: Drop table Results Step, Error = -2147217911 (80040E09)
Error string: Cannot modify the design of table 'Results'. 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)
Error string: Cannot modify the design of table 'Results'. It is in a read-only database.
Error source: Microsoft JET Database Engine
Help file:
Help context: 5003027
DTSRun OnFinish: Drop table Results Step
DTSRun OnStart: Create Table Results Step
DTSRun OnError: Create Table Results Step, Error = -2147217911 (80040E09)
Error string: Cannot modify the design of table 'Results'. It is in a read-only database.
Error source: Microsoft JET Database Engine
Help file:
Help c... Process Exit Code 1. The step failed." |
|
|
|
|
|
DTS package scheduling and SQL Server Agent